W
Wendy
Hi,
I've trawled through the posts and no one seems to be having the same
problem. I'm using Access 2007, I have a master form, with two subforms. (The
sit side by side) The first subform is a student mark sheet; textbox to enter
the test scores - textbox - tried the events, change and after update with
the following:
Forms!tblSubjectSet.qryFamOutputGrade.Form.Requery
where tblSubjectSet is the Master form and qryFamOutputGrade is the other
subform.
The results of the qryFamOutputGrade subform come from a calculated query
(standard deviation calculation).
I need the qryFamOutputGrade to requery as the results are being entered and
if the results are changed..as the std dev recalculates based upon the class
average.
I've got it to work a bit with the code adapted to:
if me.dirty =false then
Forms!tblSubjectSet.qryFamOutputGrade.Form.Requery
end if
but it never updates until a second change/update is initiated.
Any ideas?
Many thanks
I've trawled through the posts and no one seems to be having the same
problem. I'm using Access 2007, I have a master form, with two subforms. (The
sit side by side) The first subform is a student mark sheet; textbox to enter
the test scores - textbox - tried the events, change and after update with
the following:
Forms!tblSubjectSet.qryFamOutputGrade.Form.Requery
where tblSubjectSet is the Master form and qryFamOutputGrade is the other
subform.
The results of the qryFamOutputGrade subform come from a calculated query
(standard deviation calculation).
I need the qryFamOutputGrade to requery as the results are being entered and
if the results are changed..as the std dev recalculates based upon the class
average.
I've got it to work a bit with the code adapted to:
if me.dirty =false then
Forms!tblSubjectSet.qryFamOutputGrade.Form.Requery
end if
but it never updates until a second change/update is initiated.
Any ideas?
Many thanks