By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,472 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Forms with multiple records

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?

Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.