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?

[Phil Stanton]

Why not use a continuous form?

Phil

"ndunwoodie" <ni************@gwinnett.k12.ga.us> wrote in message
news:52**************************@posting.google.c om...

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?

[Janross]

Hi, Nick

It isn't really clear to me what you're trying to do, but have you considered
using combo boxes? You could have one of those showing the 5 records, and then
when the user selects a record, if the combobox control is bound to the
underlying field, it would write it to the table.

I worry about getting really lost in a loop here, but then again, I don't
understand what you're trying to accomplish.

Good luck.

Jan

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?

Jan Stempel
Stempel Consulting