rpadminserver
Board Regular
- Joined
- Nov 7, 2007
- Messages
- 111
- Office Version
- 365
Hello All.
I'm tring to get Dlookup to work in an AfterUpdate sub. Here is what I have:
Private Sub cmbTKINCONDNUM_AfterUpdate()
If Not IsNull(Me.cmbTKINCONDNUM) Then
Me.Tkincondnum_subform.Form.Filter = DLookup("tkincondnum", "tkincondition", "tkincondnum =" & Me.cmbTKINCONDNUM)
End If
Me.Tkincondnum_subform.Form.FilterOn = True
End Sub
The goal here is to get the subform to filter my records based on the Dlookup.
Thanks
Rob
I'm tring to get Dlookup to work in an AfterUpdate sub. Here is what I have:
Private Sub cmbTKINCONDNUM_AfterUpdate()
If Not IsNull(Me.cmbTKINCONDNUM) Then
Me.Tkincondnum_subform.Form.Filter = DLookup("tkincondnum", "tkincondition", "tkincondnum =" & Me.cmbTKINCONDNUM)
End If
Me.Tkincondnum_subform.Form.FilterOn = True
End Sub
The goal here is to get the subform to filter my records based on the Dlookup.
Thanks
Rob