Drop down list in a Query

[DJ]

Hello
I have a DB that containsa table of personnel and a series of safety drills
they have completed.
When I want to check which person has completed which drills I make up a
query in the design view.
I have no problem doing this, however I wish to make the query accesslble to
people who don't know how to use the design view.
My question is:
Is there a way that a query can be run so that any of the fields use a drop
down list? This would enable anyone with a minimal knowledge of Access to
use the query function. I suppose it would be like a form.
Hope that's clear!
Thanks
Dave

 

[Jeff Boyce]

Dave

Queries retrieve data, tables store it, and forms display it. Why not use a
form instead?

I can imagine a form that displays personnel info, and allows you to select
(via a combo box) which person's info is displayed. If I wanted to see
which safety drills they had completed, I would either use a listbox (based
on a query that uses the personID to filter the list), or even a subform.

Of course, without an idea of how your data is structured, the above assumes
a normalized data design, something like:

tblPersonnel
PersonnelID
FirstName
LastName
DOB
...

tblSafetyDrill
SafetyDrillID
DrillTitle
DrillDescription
...

trelPersonnelDrill
PersonnelID
SafetyDrillID
DateCompleted
...

If your data is organized more like a spreadsheet (one person, multiple
columns for completed drills), both you and Access will have to work extra
hard to do what you're describing.