sql creates a parameter rather than a criteria

[ssanfu]

@Micron
I have never used a SQL statement as a filter. I'll have to try it.

If a form HAS a record source, then to filter the form, I just use

Me.Filter = "[ApptSurname]='" & Me.cboPayeeID & "'"
Me.FilterOn

I think the OP was creating/modifying a saved query...???