Me.Dirty

[matrixindicator]

I use a Calendar object, along control source bound to a field in my table. This works fine, but in msdn documentation they said that on enter a new date on the Calendar Object the date in the field is not automatically updated. I used some code that they propose to use to update instantly the date in the field.

If Me.Dirty = true then
Me.Dirty = false
end if

however this is not doing the job. I also tried

Forms![form1].Refresh

 

[randy700]

Not entirely sure what you're trying to accomplish here but it sounds like you want to drop all changes you've made.
If so, try this...

If Me.Dirty Then Me.Undo

Randy

 

[missinglinq]

Your first code snippet is fine, matrixindicator. Where do you have it placed? Things done when a field is populated/edited are usually executed in the BeforeUpdate or AfterUpdate events. The problem is that these events only fire if the data is physically entered/changed, not when they're changed thru code, such as when a DataPicker or Calendar is used. You have to explicitly call the event.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[matrixindicator]

hello missingling

I tried to call the event. First I set a sub with the dirty code, afterwards I call the procedure

Call refreshCalendar

Am I doing something wrong, because this is not doing the job.

 

[SeeThru]

You should not need the 'call' is it is on the same form.

just enter

refreshCalendar

on a line on it's own.

SeeThru
Synergy Connections Ltd - Telemarketing Services