Finding a record

[Lourry]

Hello to all Access experts,

Can someone tell me how to put and code a "Find Record" button on a form? I tried putting the default "Find Record" button and tried it out but it's not exactly what I need.

Is there a way, that I can create a command button, then when a user clicks on it, it will open up a blank form that looks just like the main form, then the user fill in the fields and click on another button on the form and it searches the database for the matching fields and display the records?

Is my explaination clear enough?

Please help! Many thanks!

-Lory

 

[TheAceMan1]

How are ya Lourry . . . . .

You should consider [blue]Filter By Form[/blue]. Its more suited to your purpose . . . . .

See Ya! . . . . . .

 

[Lourry]

Hi TheAceMan1,

I'm new user to Access.....can you tell me step-by-step how to use Filter By Form if you don't mind?

Thanks again!