combo box search

[patti]

i have a combo box that is based on a query.
PrimaryKeyID, Lastname, Firstname.

I want the user to be able to search on the lastname but
i need the PrimaryKeyID stored.

thanks for the help.

patti

 

[Barry Gilbert]

Set the Bound column property of the combobox to 1. This makes the
PrimaryKeyId the value that will be stored in the table. In the ColumnWidths
property, put:
0"; 1"; 1"

This make the PrimaryKeyId hidden and allows the users to enter/search by
LastName.

Barry

 

[patti]

Thanks, Barry.
Your answer was clear and concise.

patti