Search records from combo box

[jgarzoli]

Hi all,

I created a table that captures a variety of data. One of the fields is LastName. I'd like to make the LastName field a combo box that I can use to search for a record. I cant seem to figure out how to make it so if I select a last name from the combo drop down list, it will automatically show the corresponding data for that record.

I'm thinking its a form and subform, but I cant figure it out. Any suggestions???

Thanks in Advance

 

[PHV]

Why not simply follow the combo wizard (3rd option) ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jgarzoli]

Combo Wizard??? 3rd Option where?

Thanks

 

[jgarzoli]

Okay, found the combo wizard, worked perfectly. So simple, thanks for your suggestion!!!