Parameter Queries & Combo Boxes

[Lissymd]

Hi

I am using a parameter query to prompt users to enter in ie their name to produce information about them. Is there a way that whent he input box prompts them, you can set or point it to a combo box for the user to select their name rather than having to type it in.

I am trying to avoid input errors and it would be useful if they could select the information rather than typing it.

Thanks

Melissa

 

[ZanyJanie]

Assuming you have a table that contains the users name you can use a form with a combobox to let the user select his/her name. In the row source for your combobox, use a select statement like the following.

select distinct [name] from [table_name] order by [name]

Then in your query, use something like the following as your selection criteria.

=forms![form name].[combobox name]

 

[sxu-mic]

I have a report that is run when user enters a month. I would like for the user to choose from a list.

I used [Corresponding Month] = Forms![FormCombo]![Combo], where FormCombo is the form name and Combo is the combo list box.

When I run the query it just prompts me for Forms![FormCombo]![Combo], instead of looking up the form itself. What am I doing wrong?