Query parameters - select from table column?

  • Thread starter Thread starter Dorian
  • Start date Start date
D

Dorian

BY embedding something like:
WHERE T.Team = [Enter Team]
in my query I can promt for a team
However, is there any way to create a prompt that allows for selection of a
column from a table. I have a table of teams tblTeams and would like the
prompt to allow selection from a column in this table.
I'm wondering if I can do this without creating a form?
Thanks.
 
Take the time to create the form with a combo box. IMO, parameter prompts are
rarely good user interface.
 
Yes, I agree but this application just displays a list of queries, allows
selection of one and then opens the query. I could create a form but then I'd
have to change the whole design of how the queries are run.
Thanks.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


Duane Hookom said:
Take the time to create the form with a combo box. IMO, parameter prompts are
rarely good user interface.
--
Duane Hookom
Microsoft Access MVP


Dorian said:
BY embedding something like:
WHERE T.Team = [Enter Team]
in my query I can promt for a team
However, is there any way to create a prompt that allows for selection of a
column from a table. I have a table of teams tblTeams and would like the
prompt to allow selection from a column in this table.
I'm wondering if I can do this without creating a form?
Thanks.
Click to expand...
Click to expand...
 
Yes, I agree but this application just displays a list of queries, allows
selection of one and then opens the query. I could create a form but then I'd
have to change the whole design of how the queries are run.
Click to expand...

What are these queries? As a rule users should never even SEE a query
datasheet, and only in unusual circumstances should they even see the name of
a query. Action queries have their place but having a user select from a list
of action queries to execute would be very unusual.

What happens when the "queries are run"? What does the user see? What's the
context?
 
Back
Top