Using a combo box to search a form

[gbanks]

I have a db which has a field called site_id it a table called sites. I have a form called sites which uses this table as a record source. I would like to make a combo box on the form as a drop down whenever the user selects a new site id it will take them to that ID on my form. I saw where you can do this with the wizard when your add the combo box to the form but it says I need to use a different table or query. Any one know how to use a combo box like this? Thanks..

 

[antonyx]

make sure the little magic wand is selected. then click the drop down icon..

put it somewhere in your form..

u will have three options.. choose the last option.. find a record based on the value...

the wizard will guide you for the rest of it.

 

[gbanks]

I know that's where I'm having a problem. It keeps telling me to select a different table/query. Can I do this manually without the wizard? Thanks..

 

[antonyx]

could u upload a copy of the database??

 

[gbanks]

Here's a simple example db.

 

[antonyx]

in ur original database u had the site_id field for each record as a drop down..

i dont know why you did this.. each record only has one site id so i changed it to a normal text box.. in the form header i have used the drop down wizard to create what you wanted..

is this what you wanted??

http://bb.1asphost.com/antonyx6/db2.mdb