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

  • Thread starter Thread starter Stephen Cain
  • Start date Start date
S

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
 
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.
 
KARL said:
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.

:
Click to expand...
Hi Thanks for the quick response will give that a go

Cheers
 
Back
Top