Preview or print different reports from the same query

[George R]

The following code does not produce any records in the report.

DoCmd.OpenReport "rptQuitDeclineList", acViewPreview, "qryQuit_DeclineList",
Resident = True, acWindowNormal, "Residents Only"

The problem is in the "Where" clause: "Resident = True". If I leave it out,
I get the complete list of those who quit or declined, so the rest of the
code seems OK.
I have tried "[Resident] = True" and "[tblOwners].[Resident] = True" and
"[qryQuitDeclineList].[Resident] = True" without success. I have also tried
all these without the square brackets without success.

Can anyone tell me the proper syntax?
Thanks for your consideration.

 

[Duane Hookom]

What happens if you try:
DoCmd.OpenReport "rptQuitDeclineList", acViewPreview, ,"Resident = True",
acWindowNormal, "Residents Only"

 

[George R]

Thanks, Duane. that worked fine.
Also, in continuing to experiment, I found that the following would also work:
DoCmd.OpenReport "rptQuitDeclineList", acViewPreview, ,"[Resident] =" & True,
acWindowNormal, "Residents Only"

What happens if you try:
DoCmd.OpenReport "rptQuitDeclineList", acViewPreview, ,"Resident = True",
acWindowNormal, "Residents Only"


--
Duane Hookom
MS Access MVP

The following code does not produce any records in the report.

DoCmd.OpenReport "rptQuitDeclineList", acViewPreview,
"qryQuit_DeclineList",
Resident = True, acWindowNormal, "Residents Only"

The problem is in the "Where" clause: "Resident = True". If I leave it
out,
I get the complete list of those who quit or declined, so the rest of the
code seems OK.
I have tried "[Resident] = True" and "[tblOwners].[Resident] = True" and
"[qryQuitDeclineList].[Resident] = True" without success. I have also
tried
all these without the square brackets without success.

Can anyone tell me the proper syntax?
Thanks for your consideration.