help with form search...

B

Brook

good day,

I have a frminventory has the following relevant field:

SizeFeet --- example of type of value 4'9" x 5'10"

I have the following code on a command button to search based on a combobox

Private Sub Command31_Click()
Dim strWhere As String
If Not IsNull(cboSizeFeet) Then
strWhere = strWhere & " AND [SizeFeet]=" _
& """" & cboSizeFeet & """"
End If
Me.Filter = Mid(strWhere, 6) 'set filter w/o extra AND
Me.FilterOn = True
End Sub

The problem is, is that i'm getting an error when I try to run the search:

Run-Time Error '2448'

You can't assign a value to this object

Does anyone know how I can prevent this error through my code?

Thanks,

Brook
 
Top