Answers to Input Box

  • Thread starter Thread starter David French
  • Start date Start date
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
 
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]
 
Back
Top