creating sql pass thru for access using VBA - help!!

I got my sql pass thru query running ok on a simple access 2000 front end, the pass thru runs an oracle stored procedure with a parameter hard coded in. Now what I want to do is replace this parameter with an entry from a field on a form, so I'm thinking that I'll likely have to generate the pass through on the fly thru VBA (which I know little to nothing about) which will insert the values from the form and run it.

In a nutshell, I have 2 linked oracle tables, one is viewed through a tabular access 2000 form for entries, deletetions and updates, the other is a dynamic table that is constantly deleted and inserted to from the stored procedure in oracle. This will also be viewed either by a report or another tabular form. On the first form I also have a command button and a text box, I want the button to generate and run the pass thru with the values in the text box as parameters.


Can someone pls tell me how to go about doing this?, or if there is perhaps a better way?

many thanks in advance!