Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Reference Subform

Status
Not open for further replies.
swambast

swambast

Technical User
Sep 25, 2000
2
0
0
US
How do I reference a subform and it's properties? For Example, my Main Form is called "MainSupport" and my subform is called "Employees Subform." How would I reference in VBA the .filter property for the subform "Employees Subform" located in the "MainSupport" form. In addition, how would I reference a field within that same subform (e.g., "StatusID"). Thanks so much for your assistance!
 
Sort by date Sort by votes
Sorry, one other note: The subform ("Employees Subform") is located on the main form ("MainSupport") under the tab named "Page27." I can't figure out how the hell-o to reference this subform...!
 
Upvote 0 Downvote
I think you have to do something like:
[Employees Subform]![StatusID].filter

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
497
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
109
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Subform not updating 1
Replies
12
Views
165
TrekBiker
TrekBiker
PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
166
PrimoSteve
PrimoSteve
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
78
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top