Querying Access

[W M]

Forgive the incredible newbieness of this question:

Is it possible to open a database, have a form pop up that allows a user to type a last name, press a "find" button and be presented with fields such as full name, address, etc. from a particular record in a query. I hope I am explaining it well enough to be understood.

I want a form that would do essentially the same function of filtering a query to a specific last name. I also want the form to be immediately open when the database is open and for the user to have a field on this form in which they can type a last name and click a "find" button. I won't ask anyone to walk me through all this step by step, but I would like to know, first if it is possible, what I am wanting, and second if anyone knows of a resource which will help me learn how to do it.

Thank you in advance,
Wendy

 

[Rick Brandt]

Forgive the incredible newbieness of this question:

Is it possible to open a database, have a form pop up that allows a
user to type a last name, press a "find" button and be presented with
fields such as full name, address, etc. from a particular record in a
query. I hope I am explaining it well enough to be understood.

I want a form that would do essentially the same function of
filtering a query to a specific last name. I also want the form to be
immediately open when the database is open and for the user to have a
field on this form in which they can type a last name and click a
"find" button. I won't ask anyone to walk me through all this step by
step, but I would like to know, first if it is possible, what I am
wanting, and second if anyone knows of a resource which will help me
learn how to do it.

Thank you in advance,
Wendy

Yes, simple in fact.

Look at Tools Startup. This is where you can specify a form to open
automatically when the file is opened. Then look at the OpenForm and
OpenReport methods of the DoCmd object in help. These allow you to open a
form or report that is pre-filtered on criteria that you supply and that
criteria can be pulled from the form that they enter the last name into.