Uncheck a check box (1 Viewer)

vcarrill

Registered User.
Local time
Today, 02:13
Joined
Aug 22, 2019
Messages
60
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

I’m here to help
Staff member
Local time
Today, 01:13
Joined
Oct 29, 2018
Messages
21,358
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

Registered User.
Local time
Today, 02:13
Joined
Aug 22, 2019
Messages
60
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’m here to help
Staff member
Local time
Today, 01:13
Joined
Oct 29, 2018
Messages
21,358
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

Super Moderator
Staff member
Local time
Today, 04:13
Joined
Feb 19, 2002
Messages
42,981
The wHERE clause for the query would be something like:

Where ReceivedDT Is Null
 

Users who are viewing this thread

Top Bottom