Database help needed. Ok. Putting it out there. I need some help. I've googled till I'm blue in the face - literally.
I have a sub form within a sub form and I need to reference a combo box on the sub form. Access only seems to write to the first sub form level.
Here's my syntax:
[forms]![Mainformname]![1st.subform].[form]![2nd.subform]![combobox]
This is a macro - after update event.
The problem is, access shows you the 2nd subform, but, I can't seem to be able to reference any of the controls on it????
The reference is so that the combo box will filter based on a synched combo box's selection which runs a requery event.
Anyone out there who knows the answer, please, please, save me some more hours of reading - thanks in advance.
I have a sub form within a sub form and I need to reference a combo box on the sub form. Access only seems to write to the first sub form level.
Here's my syntax:
[forms]![Mainformname]![1st.subform].[form]![2nd.subform]![combobox]
This is a macro - after update event.
The problem is, access shows you the 2nd subform, but, I can't seem to be able to reference any of the controls on it????
The reference is so that the combo box will filter based on a synched combo box's selection which runs a requery event.
Anyone out there who knows the answer, please, please, save me some more hours of reading - thanks in advance.
Sub sub form referencing
