Enter multiple records in 1 form?

[Mike D.]

Is there a way to enter multiple records in 1 form?

I want sort of an Excel style form that would show the
following -


| Date | Machine# | Machine Speed |
-------------------------------------
| date() | 55 | (user entry) |
| date() | 56 | (user entry) |
| date() | 62 | (user entry) |

______________________
|ENTER RECORDS BUTTON|
----------------------


Can all records be entered in at 1 time from the same
screen with machine#s already listed as shown above??

It would seem a little redundant to make the user choose
the machine# from a picklist, have them enter the machine
speed, then click to enter the record for each machine
separately.

 

[Andrew Smith]

Use an append query to add the records for each machine and the dates, then
display these to the user for them to enter the machine speed.

 

[Mike D.]

I solved my own problem. I didn't think to just add a
separate entry for EACH machine speed in the table and
have it as 1 record. duh!

 

[Andrew Smith]

You're original design was better. In the "new" design you have denormalised
the table, and are storing data in field names, which is not a good idea.