By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,282 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

LinkMaster Property

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"Scott" <sf******@earthlink.net> wrote in message
news:re******************@newsread2.news.atl.earth link.net
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


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 Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Nov 13 '05 #2

P: n/a
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
"Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote in message
news:uu**************@TK2MSFTNGP12.phx.gbl...
"Scott" <sf******@earthlink.net> wrote in message
news:re******************@newsread2.news.atl.earth link.net
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


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 Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Nov 13 '05 #3

P: n/a
On Mon, 18 Oct 2004 05:17:19 GMT, "Scott" <sf******@earthlink.net>
wrote:

In the combobox_afterupdate event, populate a hidden textbox on the
parent form:
forms!ParentForm!HiddenTextbox = DateSerial(cboYear, cboMonth, cboDay)

This should trigger the subform to requery itself.

-Tom.

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
"Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote in message
news:uu**************@TK2MSFTNGP12.phx.gbl...
"Scott" <sf******@earthlink.net> wrote in message
news:re******************@newsread2.news.atl.earth link.net
> 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


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 Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


Nov 13 '05 #4

P: n/a
"Scott" <sf******@earthlink.net> wrote in message
news:zl******************@newsread2.news.atl.earth link.net
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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.