Clear all form before record is saved (1 Viewer)

T. McConnell

Registered User.
Local time
Today, 11:38
Joined
Jun 21, 2019
Messages
63
Hey all,
I am trying to create a button to clear the entire form in case and not let the data get saved. I have a main form (frmOrders) with two subforms (fsubOrderDetails and fsubOtherInvoicedetails)
What I am wanting to is be able to clear all data on the forms and subforms making sure the data doesn't get saved.
The Me.Undo function worked for the main form at first, but once data is entered into the subform the clear button no longer works.
Any suggestions?
Thanks!
 

theDBguy

I’m here to help
Staff member
Local time
Today, 08:38
Joined
Oct 29, 2018
Messages
21,456
Hi. Correct. If the forms are bound, then the data is automatically saved as soon as you move from one form to another. This is a common topic and there should be some demos available showing how to handle this situation. One of them is to use unbound forms instead. Another is to use a temporary table.
 

Users who are viewing this thread

Top Bottom