Using a single control to enter data in multiple fields

[Wayne Morgan]

Change the Control Source of the control when you change the subject level. You may want
to do this in the form's OnCurrent event and, if you change the subject level, in the
AfterUpdate event of the control that displays the subject level.

What you may find easier is to store the number as text in the same field. When you create
your average, you could filter out the non-numeric values and average what's left.

 

[Guy Lafontaine]

Hi everyone,

I am currently creating a database that generates a student's progress
report. Subjects fall into two categories: level one subjects require text
marks (A,B,C) while level two subjects require numberic marks (1,2,3,4,5) .
In my table, level one and two marks are stored in two different fields
since one is text field and the other one is numeric (I need to generate
average). My table is made of Subject field, Level field, Level one and
Level two marks.

On a form, how can I enter any mark in a single control that will store that
mark in the right field based on the subject's level ?

Thank you.

Guy