Text and check box relationships

[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

[Jeff]

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