Combo Selection Help

[SteveGr]

Hi all,

Why is it that when I select a record from my combo box, that a different record shows up?
Sometimes the correct record shows, sometimes something else from the list shows up in my combo box.

Thanks, Stevegr

 

[sparx]

How many columns are there in your combo box??
If there is more than one column, you need to set the "bound column" property to the proper column you want to see.
Let me know if you need anything else

 

[SteveGr]

there are 4 column showing in my combo box.
How do I set the bound column?

 

[Sonja A]

Go to the properties of your combo box, click on the data tab and then set your bound column.
Sonja

 

[Pat Hartman]

The bound column must be a unique identifier for the "find" to work properly. If more than a single record could be "found" by querying on the bound column value, Access will position the recordset to one of them. The one chosen, will be random or at least unpredictable.