LinkMaster Property

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

How can I use the value in a combobox in a custom menu as the LinkMaster
property to a subform on a form?

Thanks!

Scott
 
Scott said:
How can I use the value in a combobox in a custom menu as the
LinkMaster property to a subform on a form?

Thanks!

Scott
Click to expand...

I'm not sure where the problem lies, unless you mean that the combo box
is not actually a control on the parent form. Please explain in more
detail.
 
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.

Thanks!

Scott
 
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.
Click to expand...

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.
 
Back
Top