How do I make a form in access dirty when a filed is changed programatically?

[Angelo Perillo]

The Dirty function in access is not working for a field that is "programatically" updated. Is there any solution for that?

[Stewart Ross]

The dirty property cannot be set true by programmatic intervention - unlike setting it false (which saves the current record).

When you set the field value concerned programmatically you can set up a value you can test by making use of the rather overlooked Tag property of the control bound to that field, or the tag property of the form itself, to specify that the field has been updated. Using the control's tag property as an example:

Me!YourField = <whatever you do to update the field programmatically>
Me!YourField.Tag = "Updated"

Then, where you normally test for Me.Dirty you can add a test for this tag value too:

If Me.Dirty or Me!YourField.Tag = "Updated" then
   Me.Dirty = False
   Me!YourField.Tag = ""
End If

-Stewart

[Angelo Perillo]

This solution works really well. Thanks Stewart.

[Avadhesh666]

Stewart thanks for this solution it really works.