Search Form

[karmaimages]

Hi,

I'm trying to build a database to make some work easier and to keep track of some information help on paper file (why??)

I've created my table - DWP_Date_Backend

Form - DWP Trace Form (for entering data into the database)

Form- Search_Form

What I want to do, is use the search form to query the database and display the results of the all the fields in the DWP_Date_Backend perhaps in a text box under the search fields.

On the search form i several fields to be able to search the DB

I'd like for a user to be able to enter in any of the fields/leaving blank if they wish any of them or entering multiple criteria.

Then display the result either on another form/report or under the search.

I don't want the user to be able to edit any of the data just be able to search it.

[FONT=verdana, geneva, lucida, lucida grande, arial, helvetica, sans-serif]I've tried but can't seem to be able to get search working in any shape or form. If someone could offer some advice? I have attached a sample database to this post. [/FONT]

[FONT=verdana, geneva, lucida, lucida grande, arial, helvetica, sans-serif]Unfortunately im a complete novice when it comes to access so any help would be much appreciated.

I've uploaded a sample database here: [/FONT]https://www.dropbox.com/s/d4ja5r3i6fcj4nx/DWP%20Trace.mdb?dl=0

 

[Micron]

Look here for tips and see if it fits your task
Microsoft Access tips: Search criteria