J
Jordan
Are there any examples of a form and subform where a user can enter all the
information into the mainform and subform then save all the new and/or
changed data at once.
I have a simple order entry form based on two tables OrderMaster and
OrderDetails where the master table has the Customer, Address, Phone number,
etc and the details has all the items they have purchased (Part, qty, price,
color, etc). My issue with using the easy form/subform link is that after
each item is added to the subform, the previous record changes are
automatically saved. I want to make it so a user can change or add a bunch
of different things on the subform records then decide at the end whether or
not to save the data.
information into the mainform and subform then save all the new and/or
changed data at once.
I have a simple order entry form based on two tables OrderMaster and
OrderDetails where the master table has the Customer, Address, Phone number,
etc and the details has all the items they have purchased (Part, qty, price,
color, etc). My issue with using the easy form/subform link is that after
each item is added to the subform, the previous record changes are
automatically saved. I want to make it so a user can change or add a bunch
of different things on the subform records then decide at the end whether or
not to save the data.