Uncheck a check box

[vcarrill]

Hello,

I have a database I use for ordering parts. I have a field that asks, "Open PO?" and a check box if "yes". Is there a way when I enter a date under the "Received" column that it clears the "yes" check box versus clicking on it manually? I worry about forgetting to do this and having something show as open purchase order when in fact it was received.

Thank you!

 

[theDBguy]

Hi. In the AfterUpdate event of the Received date, you could assign False to the checkbox. However, if the received date and an open po are mutually exclusive, then you may not even need a checkbox. In other words, if the received date is empty, it's an open po; otherwise, it's not.

 

[vcarrill]

I see what you are saying, so if I were to run a report for open po's, my query under "Received" would be "false" if empty or? Thank you for the advice!

 

[theDBguy]

I see what you are saying, so if I were to run a report for open po's, my query under "Received" would be "false" if empty or? Thank you for the advice!

Yes, that's correct. But, to check for empty, you would usually use Is Null.

 

[Pat Hartman]

The wHERE clause for the query would be something like:

Where ReceivedDT Is Null