Error 3075 Filtering on a form.

[Plukey]

I'm assuming its gotta be something with the data format.

Private Sub cboHull_AfterUpdate()
    Requeryform
End Sub

Sub Requeryform()
Dim strSQL As String
strql = ""
    If Len("" & Me!cboHull) > 0 Then
    strSQL = " [Hull_PS]= '" & Me!cboHull.Value
End If
    If Len(strSQL) = 0 Then
    Me.FilterOn = False
    Else
    Me.Filter = strSQL
    Me.Filter = True
End If

End Sub

.. possibly. The column I'm trying to filter has to be the Hull with PS. Ive tried a few different options & Im stumped.

 

[welshgasman]

Yes,
You start the text field with a ', but do not close it with a ' ?
You have to keep them in pairs. Same would apply if it was a date value and #

Debug.Print your sql strings before you use them, to ensure they at least look correct.

 

[Plukey]

Yes,
You start the text field with a ', but do not close it with a ' ?
You have to keep them in pairs. Same would apply if it was a date value and #

Debug.Print your sql strings before you use them, to ensure they at least look correct.

Thanks for the help...!

= "[Hull] = '" & cboHull.Value & "'"

 

[welshgasman]

I tend to use Me to indicate it is a control and not the field.
Also Value is the default property, so I leave that off as well. You do need it for TempVars though.

strSQL = "[Hull] = '" & Me.cboHull & "'"