Hello everyone. I've searched the forum and not found any help with this question:
I have a form which allows me to input the Subject, Teacher, and Classroom timetabled for each Class for each Period of each Day.
I would like to avoid as much manual data input as possible, so I'd like to set the Teacher and Classroom values by default to those recorded in a table as soon as I choose the Subject for the Period.
I know I can't enter a reference to a query in the DefaultValue parameter for the fields concerned, and I suppose I'll need to call some code OnUpdate of the Subject field. Is my hunch correct and does anyone have any examples that I could use to amend to my purposes?
Many thanks in anticipation of your replies.
Stuart