Run-time error 3075

[heinensk23]

I am getting an error



Run-time error 3075
Syntax error (missing operator) in query expression
'[Menu_Toast_Name] = 'Beef's Food' AND [Brand] = 'Beef O Bradys".


from this part of code


Private Sub casc_cmbo_FSC_MENU_AfterUpdate()


Dim myCascMenu As String
myCascMenu = "Select * from tbl_FSC_ITEM_SETUP where [Menu_Toast_Name] = '" & Me.casc_cmbo_FSC_Menu & "' AND [Brand] = '" & Me.casc_cmbo_FSC_BRAND & "'"
Me.subfrm_FSC_ITEM_SETUP.Form.RecordSource = myCascMenu
Me.subfrm_FSC_ITEM_SETUP.Form.Requery


End Sub

The weird thing is it was working until I added more data to the main table. The error only shows when the new data is there. If I remove it, I don't get the error anymore.

[Welshgasman]

Caused by the apostrophe in Beef's I suspect.?
You would get the same problem with O'Grady ?

Try 3 " """ instead of the single quote ' wherever that is used.

Alternatively remove the single quote from the data with Replace()

Put the criteria into a string variable, so you can debug.print it, and then when correct, use that in the sql ?

[moke123]

As WGMan points out it is the apostrophies that are breaking your code.
You need to use multiple double quotes to deal with it.
Something like:

myCascMenu = "Select * from tbl_FSC_ITEM_SETUP where [Menu_Toast_Name] = """ & Me.casc_cmbo_FSC_Menu & """ AND [Brand] = """ & Me.casc_cmbo_FSC_BRAND & """"

You could also use a helper function to delimit the text fields.

[heinensk23]

That was it.
It is working now.
Thanks!