Find a record using a specific field on a form or table

[Guest]

I am very new to access, the only knowledge i have is that that i learned
from the net. My question is how do i search for a record based on a
specifice field on a form and then have the specifice record opened when i
click a specified button?

 

[Fred Boer]

Dear Shauni:

You should create a form which is bound to your table, (or a query based on
your table if you want the data to have some set order). Then you could add
a combobox to the form. Users can do the search with the combobox.

There are wizards which can automate much of this for you. You could, for
example, use the Form Wizard to create the form. Then open the new form in
design view. Click on the toolbox icon, and select the combobox button. Move
to the form design grid, draw a rectangle, and follow the instructions the
Wizard provides. The combobox created will autocomplete, as an added
bonus....

Post back if this isn't detailed enough, or you have other questions!

HTH
Fred Boer

Use the wizard, and it will walk you through the process.