Forms + linking information

[Guest]

I am trying to create a form with a combo box with peoples names in at the
top and then a number of text / tick boxes underneath.

I have managed to get the combo box to work but all of the other information
on the form is not specific to the person I select i.e. it puts ticks in
boxes for everyone on my database. How do I link these tick / text boxes to
specific people?

HELP!!

 

[Guest]

Chantelle,

It may be that you're putting the cart before the horse. A form is just a
means to input and data to and from tables. If the controls on the form are
not bound to a field (i.e., the control's ControlSource property is blank),
then it will have a single value on all records of your form.

Have you created a table with the Yes/No fields? If not, modify your
table's design, be sure the RecordSource property of the form is set to the
table name or a query name based on the table, and set the ControlSource
property of each checkbox to the name of the corresponding field.

Hope that helps.
Sprinks