Look Up in Query Prompt

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Suzanne (sjoiner_at_shrm.org)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 08:24:49 -0700

I have a table tracking marketing campaigns and I am
developing a query to pull information for one specific
campaign. I added a prompt to the criteria section under
the campaign field in my query but I would like for the
prompt to offer the drop down menu (look up) that is
provided in the original table so the end-user can select
from a list and won't have to type the name in -- since
they may not know the exact phrasing of the campagin name.

However I can't seem to figure out how to make the prompt
on my query a lookup list (drop down menu).

Any ideas?

Thanks so much for the help!
Suzanne

Relevant Pages

  • Re: Dont prompt for criteria
    ... prompt for Date info, and in that case, NOT prompt for ClientID -- I don't ... criteria, and point the query to the form to get the criteria. ...
    (microsoft.public.access.queries)
  • Re: Criteria prompts
    ... how do I specify a "name" prompt? ... report, which is linked to a query. ... set this criteria to come up as prompts when the report is run? ...
    (microsoft.public.access.reports)
  • Re: Criteria prompts
    ... how do I specify a "name" prompt? ... report, which is linked to a query. ... set this criteria to come up as prompts when the report is run? ...
    (microsoft.public.access.reports)
  • Re: Slow Query when Prompts enabled
    ... This is happening because you are setting a criteria on a field from a view. ... That is why I suggest you create a pass-through query to your database ... server and change the SQL property as needed. ... I set just the query to prompt me for 1 thing, ...
    (microsoft.public.access.queries)
  • RE: Help! I need some simple statistics
    ... You can write one query for multiple dates by utilizing a prompt for user ... If you copy exactly this criteria to another field's criteria within the ... > CompletionDate as fields in my table. ...
    (microsoft.public.access.gettingstarted)