Answers to Input Box

D

David French

I have a macro that calls a query containing Parameter criteria.
There are 8 times when I need to input the same pieces of information
(Numerical Month and Year)
I would really like to enter this once and have the answers passed into each
of the parameters.
My real goal is to combine all these 4 macros containing the parameter
queries into one VB module so this may be accomplished.
My only stumbling block is how to pass the input into the parameter.

Please help.

OS - Win2K
Office XP

Dave French

dFrench at hopennmachinery (period) com
 
S

Steve Schapel

David,

Possibly the smoothest way around this is to run your macro from an
event on a form (e.g. the Click event of a command button?), and on the
form put two unbound textboxes where you enter your month and year
criteria. Then, in the criteria of the queries, instead of the
parameter prompts, you refer to the controls on the form, using syntax
such as [Forms]![NameOfForm]![NameOfTextbox]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Input box that grap data based on user answer 1
How do I set up a 'combo box' control in a Query By Form 0
input box method for macro 2
The usual "Enter Parameter Value" prompt with combo boxes 4
Input Form Design Help 2
CALCULATED VALUES FROM CURRENT VALUES IN AN ENTRY FORM 2
Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value als 1
CALCULATED VALUES IN A FORM BASED ON USER DATA INPUT 5

Top