Re: Can I use drop down boxes for a prompt in a query?

A query won't open a form. You generally open the form, enter values, and
then run the query or report.

--
Duane Hookom
MS Access MVP
--

"Stephanie" <Stephanie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:34A2409F-BCFE-4BD5-8C06-5DE1C78A8888@xxxxxxxxxxxxxxxx
> Thanks Diane, I followed the instructions but it doesn't work. When I look
> at
> the form by itself it looks right, but when I run the query I still get
> the
> prompt box although it says "enter[Forms]![Choose Region]![cboRegion] "
> now.
> How come the form isn't showing up?
>
> "Duane Hookom" wrote:
>
>> Use a combo box on a form. Parameter prompts are not very good user
>> interface. There is some information on how to do this at
>> http://www.fontstuff.com/access/acctut08.htm.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>> --
>>
>> "Stephanie" <Stephanie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:06000909-FDBE-4AC5-9AEA-2A55E3E95F12@xxxxxxxxxxxxxxxx
>> >I have a query where I want people to be able to select the criteria
>> >from a
>> > list (there are some criteria that have difficult spelling and if
>> > entered
>> > wrong people get no results). Right now the query runs with a prompt
>> > where
>> > you type in the parameter, can I change this to a drop down box? (I'm
>> > using
>> > access 97)
>>
>>
>>


.

Relevant Pages

  • Re: Beginner query help please
    ... MS Access MVP ... Duane Hookom wrote: ... I've noticed that if you select all the query output (in this ... Controls in most query solutions would not be ignored. ...
    (microsoft.public.access.queries)
  • Re: Beginner query help please
    ... MS Access MVP ... I've noticed that if you select all the query output (in this case ... Duane Hookom wrote: ... Controls in most query solutions would not be ignored. ...
    (microsoft.public.access.queries)
  • Re: Tricky query question
    ... Microsoft Access MVP ... "Duane Hookom" wrote: ... dynamic monthly crosstab report solution found at ... July data minus June data) in a crosstab query? ...
    (microsoft.public.access.queries)
  • Re: Formula will not work with mail merge
    ... There is code that does this in the Query By Form ... > How do I push the records to a separate Word Merge format file? ... >> Duane Hookom ... >> MS Access MVP ...
    (microsoft.public.access.queries)
  • Re: Crosstab Report
    ... MS Access MVP ... I try to write the report my headings/totals crash. ... "Duane Hookom" wrote: ... some of the information you posted to the query and found it very ...
    (microsoft.public.access.reports)