Need to create a search form which displays records for quick review

[milliebug]

Hi all,



I am new to MS Access and I have no database creation or computer programming experience. The database is like a hr database, but it has different information due to the fact it is for my dept in the navy. I have 5 boxes which match 5 of the fields in my database table. I would like to be able to pick a box fill in some information, and search for matching records. When I was assigned this project, I didn't realize how difficult it would be to teach myself all of this. Thank you for all of your help. Please let me know what other information you would require.

[pbaldy]

One way is demonstrated in the sample db here, though it may be a bit much for a beginner:

http://www.baldyweb.com/BuildSQL.htm

another is to use a query with this method in the criteria:

http://access.mvps.org/access/queries/qry0001.htm

My daughter is in the Air Force, just spent a couple of months at RIMPAC.