Form options (1 Viewer)

[akb]

I've created a form that prints a report created from a query.

I want the form to have two print options - to either print by Date OR Job # and I want the data pulled from the same query.

Right now I have the criteria setup in the query for the Date and Job # fields to:

DATE: [Forms]![Job Cost Form]![Text0]

JOB #: [Forms]![Job Cost Form]![Text1]

...It works if I only have one criteria setup, but does not work if I try both.

Is this possible??

 

[pbaldy]

With only 2 you can try this:

http://access.mvps.org/access/queries/qry0001.htm

I'd be more likely to use this:

http://www.baldyweb.com/wherecondition.htm

using code that did one or the other based on which the user filled out (plus handle them filling out both).

 

[akb]

Can you give me a run down on how to do option 2? The link is a bit confusing for me...Thank you