OH man - am I ever having trouble with syntax or how to go about
adding a field to a form to Filter records with a "like" modifier so
the user doesn't have to type the whole item to bring up Records.
I've got something like this
text field named [select1] which will be used to type in something
like "folder" to bring up all kinds of folders from column [DESCRIPTION]
There's an event behind a button to do the selecting:
HELP - PLEASE!!!
The trouble is (obviously) in the "Else: " line
Private Sub Filter2_Click()
On Error GoTo Err_Filter2_Click
If IsNull(Me.Select1) Then
Me.FilterOn = False
Else: Me.Filter = "OfficeFormsSupplies.Description = "LIKE "*" &
[Search Form].[Select1] & "*"""
Me.FilterOn = True
End If
Exit_Filter2_Click:
Exit Sub
Err_Filter2_Click:
MsgBox Err.Description
Resume Exit_Filter2_Click
End Sub
