Setting A Date Based on Check Box

G

Guest

Hello

I have a check box Job Complete when set to true I want to put in todays date

Here is the code based on the event after update

If Me![Duraweld Job Completion] = True Then
Me![Duraweld Job Completion Date] = Date
End If

I get an error Object or property doesn't support this method, if I change
to Date to Now() it works but puts the time in I'am running access 2002
 
B

Barry Gilbert

Phillip,

This should work. Is it failing on the Date line or the checkbox line?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Before update condition 1
display number of records on form from date range 0
Syntax for Combo Box 2
RETRIEVING DATA FROM 1 FORM FIELD UPON ACTIVATING CHECK BOX 2
Enter Parameter Values Problem 1
Field validation does not kick in 8
projecting a finish date for a project? 5
datestamp with a check box 2

Top