S
scubadiver
On the double click event of a button, I have the following code
DoCmd.SetWarnings False
DoCmd.OpenQuery "Qry CustApp", acNormal, acEdit
DoCmd.OpenQuery "List Append", acNormal, acEdit
DoCmd.OpenQuery "List Delete", acNormal, acEdit
DoCmd.OpenForm "Queries Edit form", , , "QueryID = " & Me.QueryID & ""
DoCmd.Close acForm, "menu", acSaveNo
The button is on each row of a continuous form. When I double click the
button it should run the queries and then open the edit form at the record
that I choose.
It has worked in the past but now I get a "missing operator" syntax error
and I can't think why it has doesn't work. The queryID is a number.
DoCmd.SetWarnings False
DoCmd.OpenQuery "Qry CustApp", acNormal, acEdit
DoCmd.OpenQuery "List Append", acNormal, acEdit
DoCmd.OpenQuery "List Delete", acNormal, acEdit
DoCmd.OpenForm "Queries Edit form", , , "QueryID = " & Me.QueryID & ""
DoCmd.Close acForm, "menu", acSaveNo
The button is on each row of a continuous form. When I double click the
button it should run the queries and then open the edit form at the record
that I choose.
It has worked in the past but now I get a "missing operator" syntax error
and I can't think why it has doesn't work. The queryID is a number.