Displaying fields in a form based on a value stored in a table

[Stephen Cain]

Any help appreciated:

Trying to expand a student tracking database. We have various forms for
any data input, we now wish to have a form which contains assessment
deadline dates and if passed or resubmited. However the number of
assessments vary with each course and vary from 3 through to 7
assessments.

I hold the value of the number of assessments per course in the Course
Table, what I wish to do is when a form is loaded I wish it to display the
correct amount of assessment fields for data entry for that course.

Is this possible or am I making something complex when there is a more
logical way of doing this.


disaldo

 

[Guest]

Have the assessments as a separate table linked to main information table.
In your form use a subform for the assessments. The main form can have a
field indicating the number of assessments required.

 

[Stephen Cain]

Have the assessments as a separate table linked to main information table.
In your form use a subform for the assessments. The main form can have a
field indicating the number of assessments required.

:

Hi Thanks for the quick response will give that a go

Cheers