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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stephen Cain - 14 Oct 2005 22:17 GMT

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

Reply to this Message

KARL DEWEY - 15 Oct 2005 00:01 GMT

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.

> Any help appreciated:
>
[quoted text clipped - 12 lines]
>
> disaldo

Reply to this Message

Stephen Cain - 15 Oct 2005 20:04 GMT

> 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
[quoted text clipped - 16 lines]
>>
>>disaldo

Hi Thanks for the quick response will give that a go

Cheers

Reply to this Message