By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,523 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Text and check box relationships

P: n/a
AP
I am creating a database form that has a date field and a check box.

When a user enters a date then I want the check box to automatically
be null and if no date is entered I want the check box to be ticked.

I am quite new to access to please only easy solutions

Many Thanks

Sep 20 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Sound like the default value for the checkbox needs to be set to True.

Then, in the AfterUpdate event of the date field test the field to see if a
date is entered. If so then set the checkbox to null (or do you mean
False?).

Some air code.

If IsNull([Date Text Box]) then
[chkBox] = True
else
[chkBox] = False
end if

I think you can also use a macro to do this.

You need to set the check box back to True in case they clear the date
field.

Jeff
"More Access Stuff."
http://www.asken.com.au

"AP" <pe*****@stgeorge.com.auwrote in message
news:11**********************@y27g2000pre.googlegr oups.com...
>I am creating a database form that has a date field and a check box.

When a user enters a date then I want the check box to automatically
be null and if no date is entered I want the check box to be ticked.

I am quite new to access to please only easy solutions

Many Thanks

Sep 20 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.