VBA Referencing Variables from Form

[Kyle]

Hey all, just have a quick problem.

I'm working on an Access form that has a subform. I need the subform to pull some information from another database table, but in order to do that, I need to make some dynamic query statements, using variables from the main form. I'm unsure how this can be done. There are plenty of sites online that explain how to get variables from the subform to the main form, but I haven't found any that are vice versa.

Can anyone give me an example? Thanks in advance!

[Gaffer]

should be as easy as this:

Me.txtOne = [Forms]![myMainForm].txtTwo

This takes data from textbox "txtTwo" on the main form "myMainForm" and puts it in the "txtOne" textbox on you subform....

[Ecniv]

You'll be lucky gaffer

Subforms are nightmares... avoid them and use a listbox instead (personal view)


Vince

[Gaffer]

Reference to the subform has always been a nightmare, but a reference to the main form is pretty easy I thought: I tested my theory out before I posted ...

[Ecniv]

Yup true.

I'll read more carefully in the future

You can also use Forms("formname").Controls("Controlname") but not when using instances...


Vince