D
DS
I'm using this code to sync a subform to a subform. It works fine, bu
it doesn't give me just the records for the current item. It gives me
all of the recordsfor that item. How would you put a CloneRecordset or
Bookmark in here so that it only returns the current records?
The fields are....
Main Form
ORDERS Order ID
1st Subform
Orders ID
Product ID
2nd Subform
Product ID, Mod ID
Sub Form_Current()
Dim strParentDocName As String
On Error Resume Next
strParentDocName = Me.Parent.Name
If Err <> 0 Then
GoTo Form_Current_Exit
Else
On Error GoTo Form_Current_Err
Me.Parent![Mods Detail].Requery
End If
Form_Current_Exit:
Exit Sub
Form_Current_Err:
MsgBox Err.Description
Resume Form_Current_Exit
End Sub
Thanks for any Help
DS
it doesn't give me just the records for the current item. It gives me
all of the recordsfor that item. How would you put a CloneRecordset or
Bookmark in here so that it only returns the current records?
The fields are....
Main Form
ORDERS Order ID
1st Subform
Orders ID
Product ID
2nd Subform
Product ID, Mod ID
Sub Form_Current()
Dim strParentDocName As String
On Error Resume Next
strParentDocName = Me.Parent.Name
If Err <> 0 Then
GoTo Form_Current_Exit
Else
On Error GoTo Form_Current_Err
Me.Parent![Mods Detail].Requery
End If
Form_Current_Exit:
Exit Sub
Form_Current_Err:
MsgBox Err.Description
Resume Form_Current_Exit
End Sub
Thanks for any Help
DS