Current Record / EditMode

F

Flannel

If I have a form open that has text boxes that are being
populated with data from the "current record", how can I
tell (in code) if the record is in an edit mode?

I was able to write a SELECT statement and use the
..EditMode property to return a 0 or 1 value, but I can't
get it for the current record that is in the open form.

Any help would be appreciated. Thank You
 
W

Wayne Morgan

Is the editing being done in the form? If so, you could just check for
Me.Dirty=True to see if the form is "dirty".
 
F

Flannel

That does it. Thank you Wayne.
-----Original Message-----
Is the editing being done in the form? If so, you could just check for
Me.Dirty=True to see if the form is "dirty".

--
Wayne Morgan
Microsoft Access MVP





.
 
Top