Run a macro to run query then open a form

[sadonya80]

Hello, I have a form that I will need to allow users to be able to go back and find a specific record and edit it. I have a control number to uniquely identify each record. I have a main data entry form where the subform has the unique value in it. Can I run a macro to ask the user what control number they are looking for and then open the data entry form to that specific record?

 

[*Pete*]

Hi,

In the query that the form is made from you could add [Please enter Control Number] in the Control Number field.

Have a search for Parameter Querys for more information.

Hope this helps.

Pete