Forms with multiple records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top