Run MySQL stored procedure from VBA in Access

In MySQL I have a stored procedure which uses one integer parameter -
stored_proc(n).
In Access I have a form which sets the parameter "n", either in a variable
named varN, or a textbox named txtN..
In Access VBA I can compose the concatenated query string as "call
stored_proc(" & varN & ");"
..... BUT I can't get the weird syntax of Access VBA to deliver it to MySQL.

An alternate solution attempted is an Access pass-through query - "call
stored_proc([varN]);" - and run it as an event from a command button on the
Acess form
..... BUT it doesn't pick up the variable parameter.


Any hints would be greatly appreciated, especially those which work and
don't twist up my poor convoluted VBA brain too much. I've spent a few hours
searching web sites but haven't found this combination.


Gary