Multiple Append Queries, one ID number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 8 append queries to append to 8 different tables. All of the tables
use the same ID or Case Number. They also all have relationships based off
this case number. I created a macro that would go through the append queries
one by one but since each query asks the user for the Case Number they get 8
dialog boxes they have to type into. Can VB be used to take the Case Number
once and use it as the requested info for all 8 queries?

Thank you a bunch!
 
You could create an unbound form with an unbound text box. In each of the
queries replace the parameter with a reference to the text box. It would look
something like:

[Forms]![frmFormName]![txtTextBoxName]

The user puts the Case Number in the text box. Put a button on the form to
run the macro.

As an added bonus, you could make the text box a combo box. The row source
would be a query that lists all the Case Numbers.
 
Back
Top