Subform RecordSet

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

I have a form with a 2 subforms: Names: MainForm ; SubForm1 ; SubForm2

If I am on a record in SubForm1, how can I move to SubForm2 and move to the
next record in SubForm2 if there is a next record. And do it with code.

Thank you for your help,

Steven
 
1. Save any edits in the current SubForm1.

2. Make SubForm2 the active control on the main form.

3. If it's not already at a new record, set focus to the desired control in
Subform2, and MoveNext in its Recodset.

Untested aircode, but this kind of thing:

If Me.Dirty Then Me.Dirty = False
Me.Parent!SubForm2.SetFocus
With Me.Parent!Subform2.Form
If Not .NewRecord Then
![SomeControl].SetFocus
If .Recordset.RecordCount > 0 Then
.Recordset.MoveNext
End If
End If
End With

Add error handling.
 
Back
Top