RE: Filter a Report

Thanks for the help, but my date field on the report is set to =date() in the
control source. I have set the input mask to display date in MM/DD/YYYY
format. When I use the method you told me I get a syntax error. Does it have
to do with inconsistent date format?

The other one works perfect.

Duane Hookom wrote:
I would add a text box txtReceivedOn with a default value of Date() and a
combo box cboManifest of distinct manifest numbers. Then modify the code
behind your buttons like:

Dim strWhere as String
strWhere = "ReceivedOn=#" & Me.txtReceivedOn & "#"
DoCmd.OpenReport "rptYourRpt", acPreview, , strWhere

and the other

Dim strWhere as String
strWhere = "ManifestNumber=" & Me.cboManifest
DoCmd.OpenReport "rptYourRpt", acPreview, , strWhere

I have a report that has two fields called "ManifestNumber" (number field)
and "RecievedOn" (Date/Time).
[quoted text clipped - 10 lines]

Help!

--
Message posted via http://www.accessmonster.com

.

Loading