How to open a form on a particular record using a combo box

[tigernick]

Hi,

I have created a combo box that allows the user to select a particular customer from the drop down list. I have managed to type in some code that opens the customer form after the user selects a customer, but how do i get it to open the customer form on that particular record selected by the user????

Thanx

 

[businessman]

you can use a query to do this. if you bound the form to the query and have the query search where the combo box is equal to what ever other field your looking to match with it, then the query will do all the work.