Search for a record

[Guest]

Hello,

I would like to search for a record based on the ID field (in AutoNumber
format). Preferably, the users would stay on the form. I am thinking of
either a search box or a command button running a query; any solutions or
suggestions are welcomed.

Thank you in advance.

 

[Guest]

Have you thought about creating a seperate form that is used to search? You
would need to create the form with the record source as the table that holds
the ID. The text box that the user will enter the ID to search should be
unbound. You can then add a command button to search for whatever was entered
in the unbound text box.

Hope this helps.

 

[Guest]

Have you thought about creating a search form? The form witll need to have
the table that holds the ID as the record source. Create and unbound text box
for the user to enter the data that is to be searched. You can then add a
command button that would search for the information that was entered in the
unbound text box.

Hope this helps!

 

[Guest]

Hello,

I would like to search for a record based on the ID field (in AutoNumber
format). Preferably, the users would stay on the form. I am thinking of
either a search box or a command button running a query; any solutions or
suggestions are welcomed.

Thank you in advance.

 

[Guest]

Have you thought about creating a seperate search form. Create a form with
the table that holds the ID as the record source. Add an unbound text box for
the user to enter the data to be searched. You can then add a command button
to search for the information that was entered into the unbound text box.

Hope this helps!