Richard,
I recently bought a few 300 series videos and I am still having trouble with a project.
I created a form w subform (AddPurchaseOrderF), where I would enter data for a purchase order, it works great.
But, in the office we use a specific issued work order pdf form. I converted the pdf into a jpeg image and loaded the image on a separate blank form (DHSF). Inside I created various text boxes (bound and unbound) for each area that the form needs to be filled, about 50 boxes. I am able to link the data fine, until I reach the item details area. It copies the first line fine, but the second-tenth lines are duplicates of the first. This includes description, quantity, and subtotal. Is there coding for either bound or unbound on the second-tenth lines items to know to move to the next record?
Thank you in advance

---

Reply from Richard Rost:

Steve, you could use either a RecordSet or some command loops (like Docmd.GotoRecord) to copy all of the records from one subform to another. HOWEVER, I would recommend just creating a REPORT with your custom image background on it, and then base this report on the original table. No need to copy any data. Just fill everything you need into the original form, and then PRINT it with the report so it looks like the custom "form" you're trying to reproduce.

See, one of the things that people often get confused about Access terminology is "form" vs. "report." In the workplace, we are often given paper FORMS that need to be filled out. In Access, a FORM is something you work with ON THE SCREEN. They're not really designed to be printed (yes, you CAN print them). If you want to print something, use a REPORT. They give you much better control over where things are laid out on the page.

You don't need TWO different tables to store information about the SAME THING. Just use ONE table, ONE form (for data entry) and then ONE report to print it out.