Building a search for user to find record faster

[OrganMan]

Hey,

Can someone help me out. My database is set and working great. I want the user to be able to go in and select an existing candidate from a list of over 100 candidates. All candidates have a unique id named candId. If I were to add a combo box say at the top of my form that would display the candidates last and first name, how do I code for the user to be able to select any given candidate from this combobox and it automatically go to that particular candidates record for editing. I know that this would involve the candId just not too sure how to code.

Thanks for the help.
OrganMan

 

[KenHigg]

One way: In the combo boxes on change event set the forms recordsource to a query string that uses the combo boxes bound column as a parameter.

 

[OrganMan]

Thanks Ken, I will play with it a bit more.

 

[KenHigg]

You're welcome - Let us know how it works...