"Updating" a calculated function value from a form

[andy49]

Hi guys. Need advice



I know what I can do:

Produce a list of students in a single form (showing all 30 students)

Name
Maths class
Exam paper draft (calculated by a function)

The form currently has a recordset from a query

But I'd like my 8 users (the class teachers) to be able to alter the draft exam paper value.


This information needs to be saved.

E.g. The function returns that John smith has a draft exam paper of 3-5 but his teacher would like that altered to the more difficult 4-6 exam as John is working really well.
The teacher needs to be able to change the 3-5 to a 4-6 then this value stored somewhere for future use.

Any help greatly appreciated.


Sent from my iPhone using Tapatalk

[CJ_London]

without knowing your table design, the only thing I can suggest is to have another field which the teacher can complete and your calculation field would then be something like

nz(teacherfield,whatever the calculation is)

so if the teacher hasn't entered anything, the calculation will be done

[andy49]

Thanks Ajax no idea why i didn't think of that. Definitely workable.


Sent from my iPhone using Tapatalk