Is it possible to create a pass-through query using sp_void that uses a string variable ?

I currently have a MS Access application that programmatically creates a global connection, updates Quickbooks data using various SQL statements and then closes the global connection automatically.

Everything works well, but I'm wondering if I can programmatically void specific transactions.

For example I'd like to use some code like this in a pass-through query:

 SP_VOID FROM Invoice WHERE TxnID =  '" & strTxnID & "'....where I programmatically supply the strTxnID such as A213-1150676913 on the fly.

Is something like this possible ?

Sure, just use SP_VOID just like you would use DELETE. It will void the invoice instead of deleting it. Use:

SP_VOID FROM Invoice WHERE TxnID = 'xxxxx'

or in your case:

DoCmd.RunSQL "SP_VOID FROM Invoice WHERE TxnID =' & strTxnID & '"