P
Perico
Access2k; msde backend. I have a data entry form. On the
beforeUpdate event on the "Lastname" textbox, a second
form is opened showing similar names. On the close event
of the second form, a msgbox prompts the user whether to
save or not. If 'yes', I use ADO to save the record on
the entry form.
Problem: if they select 'no', I want to cancel the
append. But I think the update event on the firstform,
the entry form, completes as soon as the second form opens
and thus the data is entered anyways, when it should not
be.
I cannot prevent the data from being entered when the user
selects 'no' on the second form close event msgbox nor
can I undo the entry. What's the best way to do get both
the save and not save to work on the first form when you
want the code of the second form to determine this ?
beforeUpdate event on the "Lastname" textbox, a second
form is opened showing similar names. On the close event
of the second form, a msgbox prompts the user whether to
save or not. If 'yes', I use ADO to save the record on
the entry form.
Problem: if they select 'no', I want to cancel the
append. But I think the update event on the firstform,
the entry form, completes as soon as the second form opens
and thus the data is entered anyways, when it should not
be.
I cannot prevent the data from being entered when the user
selects 'no' on the second form close event msgbox nor
can I undo the entry. What's the best way to do get both
the save and not save to work on the first form when you
want the code of the second form to determine this ?