Setting A Date Based on Check Box

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

Enter Parameter Values Problem 1
Excel Message box with days of month & date. 1
Code to check for proper date and time format 2
Check for duplicates with multiple criteria 1
First Effort Using VBA Code on ComboBox 3
Field validation does not kick in 8
Format Current Date 3
Date as a value to a textbox as a result from another textbox 1

Back
Top