Press "Save", add several rows to the table? 1

[JonWolgamuth]

I've posted this question here a couple weeks ago, but I think I wasn't clear about what I wanted.

I have a form where reps enter the quantity of each type of transaction that they accomplish. They should first enter their name and the date the work was completed. Then, I want them to be able to enter quantities corresponding to a list of transactions. After entering all the quantities, I want them to be able to just press "save" and save that day's work and all the different transactions to the table. I want to copy the date and name of employee for each table entry. Each table entry "per save" will differ only on transaction type and quantity.

My table consists of WorkID (autonumber), Transaction (description), Processor (who did the work), Date (the work was done), and Quantity (of the work).

Thanks in advance for any help you can give me...

Jon

 

[LarryDeLaruelle]

Jon:

Have you considered using a form in either Datsheet or Continuous form view?

This would allow the users to enter as many records as necessary without having to key a save button.

I would probably set it up as a sub form linked to the appropriate table with the main form having a combo box for the user to select his/her name.

Link the main and sub forms by the user's ID.
Larry De Laruelle
larry1de@yahoo.com