Can anyone help? I have the following situation:
I am trying to open a form blank so I set the for to data entry allowed and typed in the following code for my lookup combo box:
Dim strMyData As String
Dim strMyFilter As String
strMyData = Me![Combo42]
strMyFilter = "[LITID] = '" & strMyData & "'"
Me.DataEntry = False
Me.Filter = strMyFilter
***** Me.FilterOn = True ***** (highlighted)
End Sub
When I select from the combo box, I get the error "Run-Time Error '2001': You cancelled the previous operation. The Me.FilterOn = True portion of the code is then highlighted.
Can anyone help?
I am trying to open a form blank so I set the for to data entry allowed and typed in the following code for my lookup combo box:
Dim strMyData As String
Dim strMyFilter As String
strMyData = Me![Combo42]
strMyFilter = "[LITID] = '" & strMyData & "'"
Me.DataEntry = False
Me.Filter = strMyFilter
***** Me.FilterOn = True ***** (highlighted)
End Sub
When I select from the combo box, I get the error "Run-Time Error '2001': You cancelled the previous operation. The Me.FilterOn = True portion of the code is then highlighted.
Can anyone help?