One Form

[Sean_Sean]

i have got 2 drop-down arrows allowing the user to first select a field that will then filter out the results in the second drop-down arrow. I would then like a function that would be able to take then to that record on a form.

Is this possible?

 

[Jack Cowley]

The correct term for your drop down arrows are 'combo boxes'. The answer to your question is yes, but you need to give a bit more data. Do you want to find a record on the current form or open another form? Please give as much detail about what you want to do so someone here can give you the answer you seek.

 

[Sean_Sean]

no sorry, i now want the 2nd combo-box to take the user to a new form that will display the informaiton.

 

[Jack Cowley]

Create the Command button using the Wizard. It will ask you if you want to open the form to a specific record. Select that choice and then follow the rest of the instructions.