Each form is bound to different table?
Review Provide easier navigation between Access main and subforms - TechRepublic
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
each subform is bound to a different query
I got it to go to the next subform with the code below, and it tabs down that subform until the last record then goes to the next subfor.
But now need to go to the first record and select it. There is only one active field.
I think I'm supposed to use MoveFirst, but can't figure out how to use it in my example below
Private Sub Score_Exit(Cancel As Integer)
If (Me.Recordset.AbsolutePosition = Me.Recordset.RecordCount - 1) Then
Parent.frmShortScoresC.SetFocus
'how do I select the first record?
Recordset.MoveFirst
End If
End Sub
Try DoCmd.GoToRecord,,acGoTo, acFirst
Should work if the subform is the active object. If not, you'll have to specify the object type and its name:
https://docs.microsoft.com/en-us/off...cmd.gotorecord
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
that was it
thank you
U R welcome!
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.