P
paulgallanter
Hi,
I am using Access 2003. My “Show Site†combo box on the main form lets the
user select the general site of a show. It also controls the choices
available in a sub form combo box called “Work Sites.†So, for example,
choosing “Grand Hyett†on the main form, limits “Work Site†selection to
“Ballroom A, Ballroom B†and so on.
Here is the problem. If the Show Site changes, I can only select Work Sites
from the selections before the change. If I close the form with the new Show
Site selection and then reopen it, then the correct work site selections are
available. How would I produce this effect (showing only the correct
selections of Work Site per each Show Site, without closing and opening the
form?
Thanx, paul
I am using Access 2003. My “Show Site†combo box on the main form lets the
user select the general site of a show. It also controls the choices
available in a sub form combo box called “Work Sites.†So, for example,
choosing “Grand Hyett†on the main form, limits “Work Site†selection to
“Ballroom A, Ballroom B†and so on.
Here is the problem. If the Show Site changes, I can only select Work Sites
from the selections before the change. If I close the form with the new Show
Site selection and then reopen it, then the correct work site selections are
available. How would I produce this effect (showing only the correct
selections of Work Site per each Show Site, without closing and opening the
form?
Thanx, paul