Referencing a control on a subform from the parent form in VBA

Sometimes I get confused when trying to figure out the exact syntax required in VBA code to reference a control on a subform from the parent form.  For example Forms![Equipment]![EquipmentPartssbf].Form![cboepPartID]  

See Referencing a control on a subform from the parent form in VBA at my web site for additional details on how to make this process exceedingly simple.

Published Monday, August 25, 2008 7:37 PM by Tony
Filed under: , ,

Comments

# re: Referencing a control on a subform from the parent form in VBA

I was curious as to where you got the, uh, large, ok, monstrous 'expression builder' window.  I use some third party development tools, but I have never seen an Expression Builder replacement window.  I haven't played with Access 2007 yet, so maybe it's part of 2007.....  I was just curious in any case.

Tuesday, August 26, 2008 10:27 AM by TrentJ

# re: Referencing a control on a subform from the parent form in VBA

See the slanted lines on the lower right hand corner of the Expression Building dialog box?  I just dragged the box larger.   If that makes sense.

Tuesday, August 26, 2008 12:51 PM by Tony

# re: Referencing a control on a subform from the parent form in VBA

Well, it's official.  I am an idiot.  I have been developing in MS Access since Access 97, and I never realized that capability was there.  Unbelievable.  I hate to think about how many objects I have used the expression builder in......  DOH!

Tuesday, August 26, 2008 1:03 PM by TrentJ

# re: Referencing a control on a subform from the parent form in VBA

I'll whine about something in a newsgroup posting and someone else will say "Oh, just do this or that."  And I'm hitting my forehead doing the Homer "duh".

So you're not the only one.

Tuesday, August 26, 2008 1:08 PM by Tony

# Making the Query Expression Builder dialog box larger

In my previous blog posting Referencing a control on a subform from the parent form in VBA a comment

Wednesday, August 27, 2008 9:13 AM by Tony's Microsoft Access Blog

Leave a Comment

(required) 
(required) 
(optional)
(required)