[tiger bowden]

I have recently learned to used MicrosoftAccess and although I have used the learning tools on the net provided by Microsoft I'm still a little lost with some things.

I'm trying to develop a training/qualifications database where I would like to search for people with a particular qualification specifying the qualification and inversely searching for employee's details and individual qualifications specifying their name.

Is it possible to be able to produce drop down menus on request, where the values in the drop down menu are transferred to the desired locations (ex queries and forms).

Also is it possible to open queries/forms that require specification (for example like a wild card for the criteria in queries), where the specifications relate directly to a linked form without requiring repeated typing?

Any assistance would be much appreciated

[dr john]

You can populate a drop-down list via code (VBA) or from a look-up table.

You can take the contents of any text box or drop-down and feed that into any query, again using VBA.

And you can validate the data before it gets passed to the query to detect typical user errors too, again in VBA. EG reject non-numerical data as clearly wrong or reject something as not being a valid date.

However it's a while since I last did that, and without a copy of your database to work from, I can't write code for you.