Searches please help!! (1 Viewer)

[Sparky]

I would like to make a form or query result that searches all the database in a table. I.e. If a user types in the search criteria in a field on a form what to search for all the records that begin with the search criteria are found and shown on the form.

Is this possible, any help would be most appreciated.

Many thanks

 

[Chris RR]

Start with the query. Look up parameter queries in the Access help, that's what you want to build.

When you get the query to bring back just the records that you want, build a form based on that query. You'll need to make a little change to the query itself, so that instead of asking the user directly for the criteria, it will pick up this information from the form.

 

[Sparky]

I have used parameter queries before and it's not exactly what I need. I need to be able to enter a speficic search criteria once that searches all of the table and then pulls up the results on a form of some sort.