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 strongm 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
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
913
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
203
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Subform not updating 1
Replies
12
Views
301
TrekBiker
TrekBiker
PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
325
PrimoSteve
PrimoSteve
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
165
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top