V
Van T. Dinh
What I would do is to create a simple Form with a TextBox
for the user to enter the required ID# and a CommandButton
to run your Macro.
Change your Queries to use the full reference to the
TextBox as the Parameter.
When the CommandButton is clicked, the Parameter in each
Query will be resolved by Access using the value in the
TextBox. Thus you enter the Parameter value only once and
all Queries will use this value.
HTH
Van T. Dinh
MVP (Access)
for the user to enter the required ID# and a CommandButton
to run your Macro.
Change your Queries to use the full reference to the
TextBox as the Parameter.
When the CommandButton is clicked, the Parameter in each
Query will be resolved by Access using the value in the
TextBox. Thus you enter the Parameter value only once and
all Queries will use this value.
HTH
Van T. Dinh
MVP (Access)