C
Caledonia
I have a main form and a subform. The form is filtered based on a selection
from another form. The subform is filled by Dlookups in the current event of
the main form. These entries show the last data entered for the particular
textboxes. I want to have a box pop up anytime the user enters data in the
subform to confirm whether the user wants to save their changes. The problem
is the box pops up everytime a user clicks through the records -- even if he
isn't entering any data. I've been told that this is because the Dlookups
are dirtying the subform. So I'm looking for a workaround. I've tried
entering Me.Dirty=False in the current event after the Dlookups -- I thought
that I could fill the fields and then reset the dirty property to start with
a clean slate but this isn't working! Any ideas?
from another form. The subform is filled by Dlookups in the current event of
the main form. These entries show the last data entered for the particular
textboxes. I want to have a box pop up anytime the user enters data in the
subform to confirm whether the user wants to save their changes. The problem
is the box pops up everytime a user clicks through the records -- even if he
isn't entering any data. I've been told that this is because the Dlookups
are dirtying the subform. So I'm looking for a workaround. I've tried
entering Me.Dirty=False in the current event after the Dlookups -- I thought
that I could fill the fields and then reset the dirty property to start with
a clean slate but this isn't working! Any ideas?