Filter using a combo box

[drschlong]

Hi all,

I have a form (which I call frmDeveloper ) which is based on one table (all pretty standard stuff, Company Name, Company Address etc.) There are no combo boxes on the form as any particular company name and details will only be entered on to this form once so there is no need for one. What I want to try and do is have a button on the form so when it is pressed the user can select from a dropdown list the name of a company and then access will display the relevant record in the form frmDeveloper . I presume this would have to be done by creating some kind of other form which displays the list for the search to begin with but I have no idea where to start.

Could somebody please, please help me.

Many thanks.

Steven.

 

[Rich]

Use the combo box wizard to do the work for you

 

[drschlong]

Rich,

I'm don't want to add a combo box to the form, I need to be able to search for a particular company name by selecting from a drop down list.

So in theory the user presses a button on the form, this then brings up another form which displays the company names in a combo box. The user selects a company and then when he presses a button on this form which says for example OK the relevant record relating to that company displays in the form frmDeveloper .

I hope thats a clearer indication of what I'm trying to achieve.

Thanks in advance.

Steven. C.

 

[drschlong]

Cheers guys, that worked great. Just me being a bit thick earlier on. Thanks again.

Steven.