Hi,
I have this drop down list which is populated with the proc below. Can anyone tell me how to keep the fields shown as the key fields but for added detail in the drop down I want it to show two more fields from the data source?
Or to simplify the question can I have more than one column in the dropdown?VB Code:
Private Sub bindDropCarriages() Me.DropCarriageNo.Items.Clear() 'Get Available Carriages Me.DropCarriageNo.DataSource = Main.objCarriageBuildSheet.vwCarriages Main.objCarriageBuildSheet.vwCarriages.RowFilter = "Despatched = False" Me.DropCarriageNo.DataTextField = "Lift Serial Number" Me.DropCarriageNo.DataValueField = "Lift Serial Number" Me.DropCarriageNo.DataBind() End Sub





Reply With Quote