Form w/Unbound object and SetTempVar

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

I'm trying to run a string of parameter queries which all use the same
parameter (semester). My plan is to use a macro to open a form with an
unbound object - a combo box listing the available semesters - then use
SetTempVar to make the semester available to all the queries in the macro.

The form opens, but the macro continues running without waiting for the user
input. Now do I make the macro wait for the user's response? I don't think
I want to use MsgBox because I want the user to pick the semester from a
list, not key it in free form.

TIA
 
Back
Top