Forms that allows me to enter mutli record before saving to tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

To explain further....

I have 1 PO# with 5 items. I only want to save the record after entering all
5 items. Maybe by Using a Button control.
After confirming the PO i wish to clear the field for another PO.

How do i do with this? Using a datasheet form?
Anyone care to explain briefly so that i got a rough item
 
SeeKY,

One approach to this would be to have a have your Items subform bound to
a "holding" table, so you enter the items in there, and then when the
entries are confirmed, you run an Append Query to add these records to
the main PO Items table, and delete them from the temporary holding table.
 
A downside to this is that frequent adding and deleting records in the temp
table will make the database quickly bloat!
 
Back
Top