Combobox Returns Row Values rather than text

[lisamac92]

Please help (I have been stuck on this for 4 days now!!!)

I have created a form (frmLibrary) with a number of comboboxes which works fine. However, I have now created a subform, where I want another combox based on frmLibrary. However, I get the row number returned rather than the text contained within it.

Thanks for your help.

 

[Eupher]

You need to use column notation:

Me!txtMyField = Me!cboMyCombo.Column(x)

Where x is an integer that represents the column in the combo that holds the data you want. Remember, combo columns are zero-based, so the first column is Column(0), the second column is Column(1), etc.

Ken S.

 

[jgroh9]

If the column is based on a table or anything that has more than 1 value you will need to hide the first column or the column that you do not want to see.
You can do this by viewing the combo box properties and setting the column count to 2 and then setting the column width property to 0";3" or whatever width you want for the column you wish to view. This is assuming that the value you want to view is actually the second column. If it is the fourth column then you would need something like column count 4 and column width 0";0";0";3"
Hope this helps.