Argument Passing

Sanjeet Prasad

Registered User.
Local time
Today, 17:53
Joined
Sep 18, 2006
Messages
13
I have a statemtn like this

DoCmd.OpenQuery("UPD_RECEIPT_IMP")

When I run the above, it pops up the input box for user to key in the argument.

How can I stop this and pass the argument to the query in macro

Need help on this.Thanks...
 
If you are planning to run an action query you might consider creating the SQL expression in VBA rather than running a previously created query. By doing this you have the scope to design the query on the fly. Take a look here particularly the section "working with variables"

If it's a select query then my response here may help you i.e. declare a global variable and use a function to make it available to your query.

There may be other ways...

hth
Stopher
 

Users who are viewing this thread

Back
Top Bottom