Using tab captions as filter criteria

  • Thread starter Thread starter Jo Phillips
  • Start date Start date
J

Jo Phillips

Is there any way I may filter a subform on a tab page by the tab caption?
 
Yes, you can use the Caption property of the page.
This will return the caption of the currently selected page:

Me.TabControlName.Pages(Me.TabControlName).Caption
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit subform record source based on current tab 3
Subform to form - code won't catch up 1
Tab Control Caption 7
Show tabs with data in Tab Control 5
VBA: How can I use a string variable as autofilter criteria? 4
Disallow field sorting by users 1
Reset Label Caption to Original 0
Putting " &" in the caption format property of Option group 1

Back
Top