How to access a combo box in Access VBA

[mp3909]

I have a main form called "Form1"


Inside this form I have a command box called "x".
When you click on "x", it shows another form called "Form2"
Inside "Form2" there is a combo box called "y".

I am trying to get to "y" from "Form1" inside access vba.


I tried doing this but its not working

Me.Controls("x").Forms("Form2").Controls("y")

Please can someone help me?

Thank You

[Minty]

Bookmark this page http://access.mvps.org/access/forms/frm0031.htm and keep looking at it occasionally for the next decade....

Or use the expression builder to build the references for you.

[mp3909]

Thanks Minty for your input

I looked at the link you sent me and in my particular case, I believed I should be at the area highlighted in yellow:



so I wrote this vba code:

Me!x.Form!y

but still no luck unless I am doing something wrong?

[Minty]

Nope not right. From your description you aren't on the main form. You have opened a seperate form.

From that page you need the reference for Not In These Forms - Forms!Mainform!ControlName

Forms!Mainform!ControlName

Forms!Mainform!ControlName

[Micron]

You have opened a seperate form.

Maybe. Depends on what it "shows" means. Implies makes visible to me, not opens.
Use of common Access jargon would help.