Report Selection in Access

A

Anthony

If I have a report that has sorts by a location, how can I select when I run
the report to only show a specific location. If you could please help me
out, thanks.
 
T

Tom van Stiphout

On Thu, 28 Feb 2008 05:55:00 -0800, Anthony

You need a criteria form. Provide a dropdown with locations. User
selects one and clicks the Run Report button. You then write
DoCmd.OpenReport and in its WhereClause argument you specify something
like:
"Location = " & Me.cboLocations
If the locations are text, wrap the value in single quotes:
"Location = '" & Me.cboLocations & "'"

-Tom.
 
Top