Scott said:
Dirk,
Thank you for responding!
I am developing a calendar for scheduling training classes. Each day
on the calendar contains a subform.To maximize the available space in
the calendar, I am controlling the calendar from a custom menu at the
top of the screen. I already have selecting and changing months and
years working. Training occurs at three separate facilities so I need
a combobox in the custom menu that when a facility is selected, the
calendar changes to the schedule for that facility.
What is the nature of this custom menu? Is it a true menu bar, or just
a form that you have opened and positioned at the top of the screen?
Although you can set the Link Master Fields property of a subform
control to a reference to a control on another form, as in ...
Forms!FormName!ControlName
.... I don't think that changing the "link master" control will
automatically filter the subform the way it does when the control is on
the same form as the subform. If that's so, you'll probably have to
execute a line of code in the "menu" control's AfterUpdate event to
requery the subform(s) on your calendar form. Ot possibly, you could
put a hidden text box on the calendar form -- the main form, that is --
as the Link Master Field, and update that control with the value of the
"menu" combo box, using code in the combo box's AfterUpdate event. I
believe that should work.
