I have a Form/Subform (one to many) arrangement that allows entry of Purchases/Purchase Details. Each time a record is entered - in the subform- and we move to the next, the record is naturally stored in the Purchase Details table.
I want to be able to enter all the records BEFORE thay are stored in the table. This way the user can check the entries before they are stored and correct any mistakes prior to the records being saved to disc. This could be done, say, using an 'Enter Data' button. But is a temporary table the only way? Thus far this has proved 'clunky' at best. Is there not a way using recordsets?
Or am I going about this the wrong way?!
Thanks for your time,
Stonward.