Chapter 39 Make Controls on Forms Interactive
Chapter 39 Make Controls on Forms Interactive
Y
ou can use VBA very effectively to make the controls on a form interactive. For
example, a user may make a selection in one drop-down on your form that then
dictates the selection in another drop-down. You could also have the situation that if
a certain selection is made in a drop-down, then other controls are not visible or are disabled
for input.
If done properly, it has the additional advantage that as the user browses through records
on your form, the controls automatically react.
Here is a very simple example of how to do this.
349