drop down prompt

  • Thread starter Thread starter brigid
  • Start date Start date
B

brigid

The following code prompts the user to enter an Entry
Type.

SELECT [SIR/DIR].[Blotter Entry Type], [SIR/DIR].
[Incident Number]
FROM [SIR/DIR]
WHERE ((([SIR/DIR].[Blotter Entry Type])=[Enter Entry
Type]));

Is it possible to prompt the user with a drop down menu
so they can select the entry type? If not, does anyone
have an idea for a work around?

Thanks!
 
brigid said:
The following code prompts the user to enter an Entry
Type.

SELECT [SIR/DIR].[Blotter Entry Type], [SIR/DIR].
[Incident Number]
FROM [SIR/DIR]
WHERE ((([SIR/DIR].[Blotter Entry Type])=[Enter Entry
Type]));

Is it possible to prompt the user with a drop down menu
so they can select the entry type? If not, does anyone
have an idea for a work around?
Click to expand...

Standard self-prompting parameter queries are only useful for fairly basic stuff
as you have seen and are rarely used in production-quality applications. What
you can do instead is create a form with the drop-down list of choices and a
button that then runs the query (or form/report based on the query) and have the
query get its criteria by referring to the value on the form. The entry in the
criteria row would look something like...

Forms!NameOfForm!NameOfComboBox
 
Back
Top