Linking Check boxes to Records in a Table

[chrsab]

This is the situation:

I have one form and one table and i want to keep it that way. The form has multiple questions and for each question there is two possible answers used as check boxes. And in the table there is three columns one for the question number, one for true and one for false.

What i need is for check boxes for question 1 to be linked to record 1 in the table, check boxes for question 2 to be linked to record 2, etc.

Help!!!I have been stuck on this since yesterday and i haven't got much hair left.

Thanx

 

[KenReay]

Hi

Ok then, if you are using the wizard to create your form, just request 'Columnar' when it asks for the style of form you want (ie Tabular, Columnar, Datasheet), and the wizard will do it for you.

What you will get is a single line of controls, in the form detail section, across the form with headings (ie labels describing each column) in the Form Header section.

When the underlying table is populated with data, the row of columns will atomatically repaet down the form, the first row reflecting the datain record 1, the next for record 2 etc

Hope this is what you wanted to know.

Regards

Ken Reay

 

[GHolden]

You say..

And in the table there is three columns one for the question number, one for true and one for false.

Why do you not just have two columns Question number, and Question answer (set as a yes/no field).

Then on your form you can have one check box for each answer (ticked for true, not for false), if this check box is bound to your question answer it will automatically display the value from your table.

There are two ways to write error-free programs; only the third one works.