Forms with multiple records

[ndunwoodie]

I have table with 5 records each with 5 fields. I would like to have
these records appear simultaneously on a form (i was thinking of some
kind of bound control - not a listbox). I then plan to put a command
button next to each record so that a user could select the particular
record. Clicking the command button will cause the record to be
written to a different table along with the user's name (I know how to
do this). I can do this if I type the data into the form directly
(into to a label, textbox, etc). I'm looking for a way for these
records to appear in the form without having to enter the info
directly. Can this be done this way? If not, what's the easiest way?

 

[Lynn Trapp]

You'll probably need to use a continuous form. However, I'm wondering why
you would want to copy a record from one table to another. It's bad design
to store data redundantly in a database.