Subform to Parent Form

[DavisGail]

I am working in Access 2003. I have a purchase order database. On my new
purchase request form, I have a subform with the order details. It is
positioned on the middle of the parent form. When I leave the subform and go
to the next field on the parent form, I can no longer change the entries on
the subform. How can I make it so the subform data is not saved until I
click the submit purchase request (which is on the parent form)?

 

[KARL DEWEY]

You could have unbound forms and your 'click the submit purchase request'
button append records. When I say 'unbound' that is to the 'real data' as
you would need a temp table for more than one detail of the order. Following
the append you need to clean the temp table.

 

[John W. Vinson]

I am working in Access 2003. I have a purchase order database. On my new
purchase request form, I have a subform with the order details. It is
positioned on the middle of the parent form. When I leave the subform and go
to the next field on the parent form, I can no longer change the entries on
the subform. How can I make it so the subform data is not saved until I
click the submit purchase request (which is on the parent form)?

You can't, not without a lot of work. Access saves the parent form record to
disk the instant you set focus to the subform, and vice versa.

You'll need to bind the subform to a temporary table, and put code in the
"submit" button to run an Append query to copy it to the "real" details table.
This can be very snarky indeed when you need to edit or delete existing
records.