Combo Box problem

[MadCat]

Hi all

I apologise if this problem has cropped up on other posts, its just i couldn't find anything on it.

I have a combobox on a form which is shows two fields from a lookup table. the other fields are not shown in the combo box. The two fields are the surname and forename of a person. Within the surname fields there are multiple entries of the same surname, when i select one of these it always defaults the choice to the first instance of that surname and not the one i am specifically selecting.

Is there anyway to get this to work so that the correct name is displayed (surname and forename displayed in text box) and not the first instance.

Thanks in advance.

 

[ColinEssex]

Use an Autonumber to uniquely identify each person and then have that IDNo as the ComboBox identifier.

Col

 

[MadCat]

that works when i add a unique field to the combo box. however when the drop down box comes down, i now get the unique autonumber and the surname, but the forename is no longer visible. how do i get it so that just the surname and formname are shown. Also the ComboBox identifier, is that just the unique field included in the lookup table or is there somewhere i need to explicitly state this.

Sorry for all the questions but i'm relatively new to this.

Thanks

 

[ColinEssex]

Don't worry about being new and asking questions - even the simplest things are difficult if you don't know.

Your ComboBox now should have 3 fields. Make sure the ColumnCount = 3 and set the IDNo field as the 1st field. In the columnWidths set the first to 0 and the other 2 to whatever - say 2 and make sure the BoundColumn is 1 (that'll link the IDNo.)

See how you get on

Col

 

[MadCat]

That worked great

Thanks for your help, its much appreciated.

Cheers