Question Tick boxes/option boxes

[Burnsie]

Hello.

I have a form and subform linked to two tables by a unique subject ID.

What I want now is; on my main form I want tocreate another subform (again linked to a new table through subject ID) with a list of tick box with questions such as;

Urine check normal?
Alcohol reduction advised?
Referred to GP?

IF the box is ticked/selected I want this to link to a unique report (each subject gets their own, a query with a surname parameter is used).

any ideas, hints, tips, directions to point me in?

many thanks

B

 

[HiTechCoach]

In a properly designed (normalized) database, the "list of tick box with questions" should have each question and answer as a separate record in the table. You would NOT have one record with all the answers. That will make your life very difficult in the future.