Open report with conditions

Status
Not open for further replies.

JRPMD

Registered User.
Local time
Today, 13:58
Joined
Nov 24, 2012
Messages
52
Hello I'm trying to open a report only if fields age>=50 , gender = male , language = french and type this :

If Me.Age >= 50 Then DoCmd.OpenReport " Rpt1", acViewPreview
If Me.Gender = Male Then DoCmd.OpenReport "Rpt1", acViewPreview
If Me.language= french DoCmd.OpenReport "Rpt1" , acViewPreview

The report is open with only one condition , but I need it with three conditions. Should I use AND ?
Thank you very much.
 
Status
Not open for further replies.

Users who are viewing this thread

Back
Top Bottom