Please show us what you are trying to do I think I understand but best to look and see how we can help best.  I have done forms with several combobox and requery to dwindle down to a specific item.  I am thinking this is what you are trying to do...

V/r
Juan

Try using Me.Parent!Combobox

-Raymond

The parent is a single form, the first sub form is a single form, and the second sub form is a continuous form. The three forms are linked-- parent to child, child to child with a case number. The 2nd sub form is embedded in the first sub form.
- There is a button on the parent form that opens the sub forms.
- The second sub form (referred to below as form 2) is the one where I am using cascading combo boxes.
- When the button is pressed on the parent form and sub form 1 is opened along with sub form 2, the first combo box works, but the 2nd combo box isn't working because its data query can't find the reference to the first combo box. I get a prompt after I have made selections in the two combo boxes.
- Using "Forms!Mainform!Subform1.Form!Subform2.Form!combo box" to refer to the first combo box in the 2nd combo box query didn't work. Is it supposed to work in SQL?

did you try Raymonds answer?  what happen?

V/r
Juan

It didn't work. I tried leaving it as Me.Parent! followed by the Combobox name, as well as the actual name of the parent form. Neither one worked.
Is Me.Parent!Combobox supposed to be used in the query or someplace else?

Don Have you tried this, make a button to drop down the combo?

Forms!Mainform!Subform1.Form!Subform2.Form!combobox.SetFocus
Forms!Mainform!Subform1.Form!Subform2.Form!combobox.Dropdown

Your code seems to be correct
Forms!Mainform!Subform1.Form!Subform2.Form!combobox

Darrin Would I use these in the on click event?

I also have questions about using Me.Parent.Combobox. My cascading combo boxes are located on the subform 2. There are no comboboxes on the parent form, so why would I be referencing a combobox on the Parent form-- or am I totally misunderstanding how Me.Parent.Combobox is supposed to work?

I've never heard of using Me in a data query. Didn't know that was even possible. I thought you had to give the full reference.

Don Yes you would use a button with a click event

I tried the parent didn't work for me.

I made the Mainform, Subform1, Subform2 and put Subform2 into Subform1 then add Subform1 to the Mianform.

So Forms!Mainform!Subform1.Form!Subform2.Form!combobox is correct, but what are you doing with it?

The button is just for testing to make sure your combo can be reached in Subform2 from the Mainform.

My Subform1 is in the Mainform and Subform2 is in Subform1, just you've indicated above.

In my case, it's Forms!ClientDataControlF!CaseMgtF.Form!CaseMgtSub.Form!RefCatCBO. In the query design of the 2nd combo box on subform2, it's the criteria.

I will try to use the focus tip you suggested. Thanks!

References to controls within nested subforms in query criteria can be tricky, especially with continuous forms. If you're still having problems, post some screenshots.