Me.Dirty is True but no changes have been made to form

[projecttoday]

I have a form with a button on it. This is a close form button. When clicked it hits

If Me.Dirty Then

followed by a prompt that asks the user if he wants to save the record. The problem is Me.Dirty is coming up true even when no entries have been made on the form. I have used this same code in other databases and it worked. Any ideas?

Robert

 

[RoyVidar]

Probably you have code in the form that dirties the record, for instance some assigning of value to controls in the forms on current event or something similar.

Roy-Vidar

 

[ProgramError]

How about trapping the code with a break.


Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[T111]

Use the event before update or after update!

 

[projecttoday]

Roy-Vidar I think you are right. I have a field in the table where I want to put a date stamp whenever a record is changed:


Private Sub Form_Current()
[editdate] = Date
End Sub

I tried

Private Sub Form_Current()
I Me.Dirty then
[editdate] = Date
End If
End Sub

and I got an error message. Any ideas?

 

[RoyVidar]

Use the before update event of the form. That triggers when a save is performed.

Roy-Vidar

 

[PHV]

For the automatic change timestamp:
Private Sub Form_[!]BeforeUpdate[/!]()
Me![editdate] = Now
End Sub

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[projecttoday]

Whoa! You guys are fast. I thought of that right after I clicked submit. It's working now. Thanks all.