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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding new records to subforms 3
Adding a new record to a subform 1
Cancel the changing to a different record in a subform 1
Referrring to SubForm Controls 5
Eliminate prompt in requery of subdatasheet in vba 6
Referencing control in subform from subform's subform 5
How to always get the top level form reference, when calling from any subform/subform... 0
Run Code on one subform from another subform 2

Back
Top