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

S

SeeKY

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
 
S

Steve Schapel

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.
 
P

PC Datasheet

A downside to this is that frequent adding and deleting records in the temp
table will make the database quickly bloat!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box choice checks a box in another database table via dlooku 3
Validation strategy 5
Determine subform total before code runs 2
Validation to assure there is a subform record 2
Purchase Order form questions 6
Automatic record generation 2
select subform records to add to table and report 3
Pass subform total to main form 2

Top