connecting comboboxes in a subform

[Mike]

Hi guys,

i have a form(myform) where i connected a pair of comboboxes for
managers and supervisers, so when you choose a manager the second
combo shows only those supervisors who report to him. So i had a query
for supervisors list where i put a condition under managers name:
[Forms]![myform]![Fa_manager] and also an after update requery
Me.FA_supervisor.Requery. SO everything worked fine.

Then i had to add more text boxes and combos to my form and it became
really crowded, so i decided to add 2 tabs and two subforms for each
tab accordingly. Managers and supervisors combos were moved on
subform1 and now i'm spinning the weels trying to make them work as
they did on a single form.
Tryed to adjust the query condition to [Forms]![subformform1]!
[Fa_manager] and some modification to the Requery code but alas.

Could someone give me a headup how to get over this issue? Maybe i
should create an invisible textbox on myform, connect it to the
managers combobox in the subform1 and requery the new textbox?

Thanks and Regards

Mike

[Wayne Gillespie]

On Fri, 7 Mar 2008 08:01:13 -0800 (PST), Mike <mi*************@hotmail.com>
wrote:

>Hi guys,

i have a form(myform) where i connected a pair of comboboxes for
managers and supervisers, so when you choose a manager the second
combo shows only those supervisors who report to him. So i had a query
for supervisors list where i put a condition under managers name:
[Forms]![myform]![Fa_manager] and also an after update requery
Me.FA_supervisor.Requery. SO everything worked fine.

Then i had to add more text boxes and combos to my form and it became
really crowded, so i decided to add 2 tabs and two subforms for each
tab accordingly. Managers and supervisors combos were moved on
subform1 and now i'm spinning the weels trying to make them work as
they did on a single form.
Tryed to adjust the query condition to [Forms]![subformform1]!
[Fa_manager] and some modification to the Requery code but alas.

Could someone give me a headup how to get over this issue? Maybe i
should create an invisible textbox on myform, connect it to the
managers combobox in the subform1 and requery the new textbox?

Thanks and Regards

Mike

The full reference to the combo would be -

Forms!myForm!Subform1.Form!Fa_Manager

Forms!MyForm references the main form.
!Subform1 references the subform CONTROL on the main form.
..Form references the FORM contained within the subform1 CONTROL.
!Fa_Manager references the combo within the subform.
Wayne Gillespie
Gosford NSW Australia

[Mike]

On Mar 7, 12:00*pm, Wayne Gillespie <[e-mail]>
wrote:

On Fri, 7 Mar 2008 08:01:13 -0800 (PST), Mike <[e-mail]>
wrote:

Hi guys,

i have a form(myform) where i connected a pair of comboboxes for
managers and supervisers, so when you choose a manager the second
combo shows only those supervisors who report to him. So i had a query
for supervisors list where i put a condition under managers name:
[Forms]![myform]![Fa_manager] and also an after update requery
Me.FA_supervisor.Requery. SO everything worked fine.

Then i had to add more text boxes and combos to my form and it became
really crowded, so i decided to add *2 tabs and two subforms for each
tab accordingly. Managers and supervisors combos were moved *on
subform1 and now i'm spinning the weels trying to make them work as
they did on a single form.
Tryed to adjust the query condition to [Forms]![subformform1]!
[Fa_manager] and some modification to the Requery code but alas.

Could someone give me a headup how to get over this issue? Maybe i
should create an invisible textbox on myform, connect it to the
managers combobox in the subform1 and requery the new textbox?

Thanks and Regards

Mike

The full reference to the combo would be -

Forms!myForm!Subform1.Form!Fa_Manager

Forms!MyForm references the main form.
!Subform1 references the subform CONTROL on the main form.
.Form references the FORM contained within the subform1 CONTROL.
!Fa_Manager references the combo within the subform.

Wayne Gillespie
Gosford NSW Australia- Hide quoted text -

- Show quoted text -

Thanks Wayne,
i have changed the query reference to [Forms]![frm_fundinput]!
[subfrm_fundinput2].[form]![Fa_manager]
but nothing happens, when i choose Manager the Supervisors combobox
remains empty for some reason.
Do i also have to adjust the AfterUpdate requery code?
Thanks
Mike