criterion for query entered from open form

[tekboy]

I have a roport that is tied to a query. The query currently prompts the user for a shipping tally number. The query in turn uses that input as its critereon for its search. The report mentioned above is launced by a button on a form. That form also has the shipping tally number allready available in a field. Can I make the value from the "shipping tally field" in the form become the criterion for the querry automatically? So the user doesnt have to manually enter the value?

 

[hymn]

Yes
In the Query for the report type [forms]![Form Name]![field name}in the criteria row on that field

 

[tekboy]

NOt working...any ideas on what to check? I double checked the code and entered it almost exactly as you said. xcept the last } wich I think you ment it to be a ]. Suggestions?

 

[GDGarth]

[Field Name] is the name of a text box on the form, right? It isn't the name of a field in a table. check that to make sure you have it right.

I find it's easier to get it right if I use the expression builder. Just right click in the criteria field, and choose "build". Then select the proper form and text box (or combo box).

 

[allcarfan]

You may want to recheck the name of the textbox on the form too. Make sure you are not confusing it with the label. This technique is called query by form. Here is a link to the microsoft website on exactly how to do it.

http://support.microsoft.com/default.aspx?scid=kb;en-us;209645

 

[grnzbra]

go into the query and switch to the SQL view. the where clause has to look somehting like"

"...
WHERE [tally number] = '" & [Forms]![FormName]![FieldName] & "'".

assuming that the tally number is an alpha field. If this is your problem, you should get an error message indicating that a parameter is missing.