S
SAP2
Don't see my earlier post... here I go again!
Scenario:
Main form (1)- frm1 based on tbl01
User enters 3 parameters to filter by p1,p2,p3
Subforms (6)- fsub1-fsub6 (each with its own tab) also based on tbl01
ALL subforms are Linked to frm1 through 2 fields (p2,p3)
When the 3 parameters are chosen fsub1 will list the basic info associated
with them. fsub2-fsub6 will list more specific info.
With the following additions suggested by Robert Carlson:
fsub1 On current Event:
Forms![frm1]![fsub2].Requery
fsub2 On Current Event:
If IsNull(Forms![frm1]![fsub1].Form!ID) = False Then
Me.RecordsetClone.FindFirst "[ID] = " & Forms![frm1]![fsub1].Form!ID
Me.Bookmark = Me.RecordsetClone.Bookmark
Else
Forms![frm1]![fsub1].SetFocus
DoCmd.GoToRecord , , acNewRec
End If
This syncs the records across the tab (when tab is clicked)when p2/p3 has
multiple records associated with it but if a new record is added fsub2 does
not go to that new record until I toggle through the records in fsub1.
What I want to happen is when a new record is chosen in fsub1 THAT new
record will show up for edit in fsub2 (when the tab is clicked) and fsub3 and
fsub4... and so on.
I hope this was clear. I am not proficient with VBA so bare with me. Any
help would be much appreciated. Thanks.
Scenario:
Main form (1)- frm1 based on tbl01
User enters 3 parameters to filter by p1,p2,p3
Subforms (6)- fsub1-fsub6 (each with its own tab) also based on tbl01
ALL subforms are Linked to frm1 through 2 fields (p2,p3)
When the 3 parameters are chosen fsub1 will list the basic info associated
with them. fsub2-fsub6 will list more specific info.
With the following additions suggested by Robert Carlson:
fsub1 On current Event:
Forms![frm1]![fsub2].Requery
fsub2 On Current Event:
If IsNull(Forms![frm1]![fsub1].Form!ID) = False Then
Me.RecordsetClone.FindFirst "[ID] = " & Forms![frm1]![fsub1].Form!ID
Me.Bookmark = Me.RecordsetClone.Bookmark
Else
Forms![frm1]![fsub1].SetFocus
DoCmd.GoToRecord , , acNewRec
End If
This syncs the records across the tab (when tab is clicked)when p2/p3 has
multiple records associated with it but if a new record is added fsub2 does
not go to that new record until I toggle through the records in fsub1.
What I want to happen is when a new record is chosen in fsub1 THAT new
record will show up for edit in fsub2 (when the tab is clicked) and fsub3 and
fsub4... and so on.
I hope this was clear. I am not proficient with VBA so bare with me. Any
help would be much appreciated. Thanks.