pbuethe
Returning User
- Local time
- Today, 04:41
- Joined
- Apr 9, 2002
- Messages
- 210
I have:
Main form – frmDenialTracking
Combobox on main form – cboProvider
Subform – sfrmDenialTracking (this is the name of the subform AND the subform control)
The combobox selection provides criteria to a query which I am changing the recordsource of the subform to.
When I select from cboProvider, I get run time error 2465 – "application-defined or object-defined error"
The line Me!sfrmDenialTracking.Form.LinkChildFields = "[CaseNbr]" is highlighted in the following code:
Thanks in advance for your help.
Main form – frmDenialTracking
Combobox on main form – cboProvider
Subform – sfrmDenialTracking (this is the name of the subform AND the subform control)
The combobox selection provides criteria to a query which I am changing the recordsource of the subform to.
When I select from cboProvider, I get run time error 2465 – "application-defined or object-defined error"
The line Me!sfrmDenialTracking.Form.LinkChildFields = "[CaseNbr]" is highlighted in the following code:
Code:
Private Sub cboProvider_Change()
Me!sfrmDenialTracking.Form.RecordSource = "qryfrmDenTrackingActionNeeded"
Me!sfrmDenialTracking.Form.LinkChildFields = "[CaseNbr]"
Me!sfrmDenialTracking.Form.LinkMasterFields = "[CaseNbr]"
Me.Requery
Forms!frmDenialTracking!sfrmDenialTracking.Form.Visible = True
Me.cboCaseID.Value = Null
Me.Refresh
Me.sfrmDenialTracking.Form.FilterOn = False
Me.sfrmDenialTracking.Requery
End Sub