Input Multiple Recrds using 1 form

[Guitarcam87]

Here's what I have:

tblOperatorAssignments
[Date], [Shift], [Press], [Operator]
frmOperatorAssignments

I need to be able to enter all operators and presses as individual records in the table so it would look something like this:

[Date] [Shift]

[Press](Default "1") [Operator]
[Press](Default "2") [Operator]

And so on.

I also need the date and shift in each record as well.

Am I going about this all wrong??? Please help! Thanks in advance!!!

 

[deanvilar]

am going to do something like that too, in my opinion you must have a list box or grid to store your data before saving it in table .... then to save it in the table you must create a code to take all data in each row and save it ... good luck in your project