Hi,
I have a sub-form with a load event as follows:
This runs a complex query of data (in a public module) and loads the sub-form as a continuous form with the last fifteen records displayed.
My problem is that on the main-form I have instances where I requery the data and cannot get it to reflect the above.
This re-queries the data but doesn't move to the correct record, so I tried:
This still re-queries the data but doesn't move to the correct record, however adding the GoToRecord falls over as it cannot reference the correct form.
Any suggestions would be most helpful.
I have a sub-form with a load event as follows:
Code:
Private Sub Form_Load()
testresults
DoCmd.GoToRecord , , acLast
DoCmd.GoToRecord , , acPrevious, 14
End Sub
My problem is that on the main-form I have instances where I requery the data and cannot get it to reflect the above.
Code:
Private Sub tBlade_AfterUpdate()
Me.subform.Requery
End Sub
This re-queries the data but doesn't move to the correct record, so I tried:
Code:
Private Sub tBlade_AfterUpdate()
testresults
End Sub
Any suggestions would be most helpful.