choose option from drop down menu to open report

[laurat]

I have a report based off of a query. When a user opens the report it asks them to type in a certain piece of data so that the report displays only the records with that data. The problem is the code has to be typed in perfectly in order for the record to appear in the report (the data is first enterd into that field on a form with a drop down menu so they are all entered the same). My question is, instead of asking users to type in the data when opening the report is there a way to have this be a drop down menu as well and they can just choose the specific data??

 

[TessB]

of course!

Simply make the DropDown box using the wizard on the query form. Of course you will have to change your criteria on your query to reflect that now it is looking for a value in a combobox.

 

[Shane_Mc]

Simple enough,

Build a form with a combo box or list box of the values you want to be able to enter.

I presume your report is running of a query if you want to limit your results to certain values.

So, in the criteria field of the query enter the following

[forms]![my form]![my field]

where "my form" is the name of your form and "my field" is the name of the combo box or list box.


Shane

 

[Shane_Mc]

U got in before me Tess!

 

[laurat]

no luck

Ok...I must be doing something wrong. There is a combo box on a form already that I used the wizard to create with the values I needed. The report is based off a query that had [Enter the disposition: ] in the criteria box in the disposition field. I changed this to say [Forms]![Disposition Entry]![Disposition] Disposition being the field that has the combo box. Now when I run the report based off this query I get a message box that says [Forms]![Disposition Entry]![Disposition] instead of a drop down menu which I want....help please!!!

 

[TessB]

It may be that you just forgot the = or "Like" in your criteria.
Thus, your criteria should read =[Forms]![Disposition Entry]![Disposition] or Like [Forms]![Disposition Entry]![Disposition]
Also, to run the report, make sure that you have the form opened and the desired combo box value selected.

 

[RichMorrison]

You do not want an equal sign ("=") in the Criteria cell of a query.

RichM

 

[TessB]

Thanks Rich. Is there a reason for the equal sign messing up a query? Does it have to do with the difference between strings and values or something?

Waiting to learn ...
Tess

 

[RichMorrison]

Tess,

I don't know. Maybe some slow day I will test the differrence. Maybe it doesn't matter at all

RichM