I don't believe you can place a SQL string directly into
the RecordSource property with a variable comparison
operator, in this case and/or.
You should build the SQL string in code. Here's an
example. The syntax is correct, just substitute the
actual table, field, form, and control names. You could
run this from the OnClick() event of a command button or
almost any other event you deem appropriate. Good luck.
Dim strSQL as string
strSQL = "SELECT table.* FROM table " _
& "WHERE [Field1] Like '*" & Forms!MyForm!CBox1 _
& "*' " & Forms!MyForm!Logic.Caption _
& " [Field2] Like '*" & Forms!MyForm!CBox2 & "*'"
Forms!MyOtherForm.RecordSource = strSQL