Combo box and parameter queries

[Guest]

Good afternoon,

I am using a parameter query to prompt a user to enter a specific office in
order to pull data for that office. I would like them to be able to select
this office from a drop down menu instead of typing that in. Is there a way
to do this if I setup a table of office names? I know how to setup lookups
and combo boxes for tables, but not for a parameter query criteria. What do I
need to type in the critieria section of the field? I've got [Enter Office
Name?] there now but this prompts for name to be typed. Any suggestions?
Thanks.

 

[Larry Daugherty]

[forms!MyForm!MyCbo]

HTH

 

[Guest]

I also need to do this same thing. I want to have a parameter box that has a
combo box drop down with the specific enteries people can choose, but because
of my lack of knowledge, this reply isn't very helpful to me. Do I put the
bracketed words in the criteria of the query as is? I tried this and it did
not work. If you could give a more specific answer, that would help me out.

~Angela

[forms!MyForm!MyCbo]

HTH
--
-Larry-
--

Good afternoon,

I am using a parameter query to prompt a user to enter a specific office in
order to pull data for that office. I would like them to be able to select
this office from a drop down menu instead of typing that in. Is there a way
to do this if I setup a table of office names? I know how to setup lookups
and combo boxes for tables, but not for a parameter query criteria. What do I
need to type in the critieria section of the field? I've got [Enter Office
Name?] there now but this prompts for name to be typed. Any suggestions?
Thanks.