Automatic record creation

[Dangermouse]

Hi, I’m not sure if this possible, I have created a inventory database in
Access 2003, I have a product form, from which using an event procedure on
the PO field I can call the PO Form, I enter all relevant information
supplier / cost etc.., and the quantity,

This is where I need your help, I need to call another procedure that
creates a number of records to equal the quantity, e.g. 5 products ordered =
5 records created, I can then add the required data for each product when
they arrive, e.g. serial number etc…

I just cant get my head around the code, to do this, can you help me

The relevant tables are joined

Thanks

Dangermouse

 

[Jeff Boyce]

It sounds like you've decided that the way to handle this is to create empty
records awaiting further data entry.

What about waiting until you actually have data to enter, then creating each
record on-demand?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.