Slect specific record from Combo Box

  • Thread starter Thread starter Global777
  • Start date Start date
G

Global777

I am using a combo box to select from a db of 8000+ records. The items
in the list are LName, FName, Uique ID. I am using the wizard. Many
of the records share the same last name. Currently I have to select
'Smith', for example, and then go down to the record selector and click
until I reach the specific 'Smith'.

How do I set up the combo the let me select by the last name but be
able to select a specific record and populate the form based on the
unique ID?

Thanks in advance.
 
I am using a combo box to select from a db of 8000+ records. The items
in the list are LName, FName, Uique ID. I am using the wizard. Many
of the records share the same last name. Currently I have to select
'Smith', for example, and then go down to the record selector and click
until I reach the specific 'Smith'.

How do I set up the combo the let me select by the last name but be
able to select a specific record and populate the form based on the
unique ID?
Click to expand...

If you include all three fields in the combo box, and use the unique
ID as the bound column, then it should find an individual person!
Could you post the VBA code that the wizard generated? It should be
easy enough to fix.
 
Thanks for your help. I have used the Properties box and trie
selecting column 3 (the column with the unique id) but it causes th
combo box to quit working all together.

I have not had much experience using VBA code. My next thought was t
structure a SQL statement and paste it into the Row Source i
Properties.

Is there anywhere I can go to find basic VBA snippets?

Thanks again for your help,

Stev
 
Back
Top