Form Criteria

[Z1nkstar]

I have a Form that use to Only show Records that dont have a produce by date well I just found out that it had broken some how this is what it looks like and everything works its just it wont show anything when I put in False as the Criteria.



I am trying to fix it I have tried everything I know to do I just cant get it to work its BROKE

[Z1nkstar]

This is What I get when I try to use form anywhere

[John_G]

First, if ProduceByDate is a Date field, then False is not a valid criteria value. If you want to find records where there is no data in ProduceByDate, use Null as the criteria.

[Z1nkstar]

I havent tried that but I wouldnt know where to start either I havent ever attempted anything like that.

[Z1nkstar]

I put in Is Null is that the Same Command?

[Z1nkstar]

Okay Null Works wow I tried that before and it didnt so I guess IDEK

[John_G]

What happens when you run the query qryProduction_Uncheduled? Does it result in any data being shown?

If it does display data, there is no reason that I can see the form won't work.

[Z1nkstar]

I don't Understand because When the database was first created we used False and it worked so should I be concerned about all the other falses on Date Fields?

[John_G]

Yes. The only datatype that should have True/False in the criteria is Yes/No, or expressions that evaluate to True or False. Use Null to test for empty fields.

[Z1nkstar]

Okay thanks By the way I didnt Design or Right the Database I am just the fill in the Fix all of that guys mistakes.