View Full Version : Search Access Database - based on user input

07-11-2008, 01:27 PM
Hi all,

1stly... I am no expert with Access but would like to get to know it better.

I am trying to create a button on a form which, when clicked prmts the user to input the desired search criteria... for example by Asset Number?

Once they enter this data they click ok and the search is initiated...
If entries are found the results need to be displayed.
If no entries are found then a message needs to be displayed saying... "No such entry found? or something like that.

I have 1 table called Asset_Details and 1 form called Main_Assets.

Any help would be appreciated.


07-11-2008, 01:33 PM
Use a parameter query for searching vary user input.

Sorry got to go so don't have time to explain properly but a google search should yield a fair bit of info.

Speedy Gonzales
07-11-2008, 01:34 PM
You mean something like this ? (http://support.microsoft.com/kb/304352)