Syntax troubles: DoCmd.OpenForm with Boolean where 1

[ThinWhiteDude]

Am having some trouble with syntax on DoCmd.OpenForm and using a where clause. I would like to open the form and show only the records where the ysnPlantMgrReviewed field is equal to No. Here’s what I have tried, and is not working:

DoCmd.OpenForm "frmObservations", acNormal, , "ysnPlantMgrReviewed=0"

I don't get an error message, just no data when I should.

This is the first time I’ve tried to use the where condition with a Boolean field, so I’m lumbering along here. Couldn’t find this through various searches on the forums, not to say it isn’t there, just might not have known quite how to search for it.

Anyhow, any help will be greatly appreciated,
TWD

 

[TheAceMan1]

How are ya ThinWhiteDude . . . . .

Not sure what you have but try:

[blue]"ysnPlantMgrReviewed='No'"[/blue]

or . . . if its a boolean field (checkbox), try:

[blue]"ysnPlantMgrReviewed=False"[/blue]

See Ya! . . . . . .

 

[ThinWhiteDude]

AceMan1,

That did the trick, thanks for your help again and have a star!
TWD