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