Priting a report based on WHERE condition in the form (1 Viewer)

josephbupe · May 18, 2018

Hi,

I have WHERE condition declared under a Search button for programmatically searching a table through multiple input controls on a form.

I would like to know how i can open a filtered report based on the same

Code:

strWhere

condition.

Under a CmdPrint button I tried

Code:

DoCmd.OpenReport "R_EVENTS", acPreview, , strWhere

but this gives an

error Variable not defined

, referring to

strWhere

Any tips will be appreciated.

jdraw · May 18, 2018

joseph,

This material by Martin Green has a lot of info and sample code re Dynamic Reports.
I hope it is useful to you.

Good luck.

josephbupe · May 18, 2018

Okay, I will check it out.

Thanx

bastanu · May 18, 2018

Joseph,

Move the strWhere declaration from inside the sub where you do the search to the top of the form module if on the same form.

Cheers,
Vlad

josephbupe · May 18, 2018

bastanu said:
Joseph,

Move the strWhere declaration from inside the sub where you do the search to the top of the form module if on the same form.

Cheers,
Vlad

Hi bastanu,

I appreciate that. Thanks

Pat Hartman · May 19, 2018

The strWhere variable must be populated with a proper condition. For example.

strWhere = "SomeField = " & Me.Somefield & " AND SomeOtherField = " & Me.SomeOtherField

Priting a report based on WHERE condition in the form (1 Viewer)

josephbupe

Registered User.

jdraw

Super Moderator

josephbupe

Registered User.

bastanu

AWF VIP

josephbupe

Registered User.

Pat Hartman

Super Moderator

Similar threads

Users who are viewing this thread