multiple records on a form

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

Guest

I know all the basics of Access and Visual Basic. I want to create a
database that will do the following. I have a table with a number of records
that I want displayed simultaneously on a form. I then want to create a
command button next to each record that will allow a user to choose one of
the records. The one chosen will then be written to a different table from
which I could, through queries, create various reports. It seems that I
could do this with a listbox, but I was thinking of something different.
Something with bound controls to the records in the original table, perhaps.
For some reason, I just can't think of an easy way to get these records onto
the form without a listbox. Any thoughts?
 
To get multiple records on a form, make the form a continuous form, or
include one as a subform.

As far as writing to another table and creating duplicates of your data, why
not just add a checkbox to the records and allow the user to select the ones
they want to include by checking the box.

You would also want a button to "uncheck" all records.

Rick B
 
I really appreciate your response. I've had no experience using continuous
forms. After reading your answer, I did create one for this form. It now
shows all the records from the table.

As for my task at hand: Employees have to choose 2 of the records
presented. I would need to record/show all the record 1 choices, all the
record 2 choices, etc. I would also need to record/show what choices a
particular employee made if they requested. As one of the fields in the
continuous form, I put a combo box for the employee to pick their name so
that it would be associated with their coice. This would allow them to be
recorded with the info for the particular choice. The problem is, when the
employee picks their name from the combo box it populates all the combe boxes
for each record on the continuous form - thereby selecting all the coices.
Any way for an employee name to be associated with just the choices they want?
 
Back
Top