UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Tabbed Form Name in Queries    
 
   
UAVtrainer
post Dec 2 2004, 04:17 PM
Post #1

UtterAccess Member
Posts: 21
From: CA-High Desert
Folks,
I would like to use the tab name in a tabbed form to "filter" the subform on that tab. Having a hard time finding the appropriate method to accomplish this. I want to use a general name like [tabcntl3].[tab.name] so that only one query and subform is required. Thanks
Go to the top of the page
 
+
Jack Cowley
post Dec 2 2004, 05:14 PM
Post #2

Retired Moderator
Posts: 37,716
From: The San Francisco Bay Area
Subforms can be 'filtered' by the links between the subform and main form. Have a hidden control on the main form and use that as the Master link in the subforms MasterLink property. Now you can use code to change the value in the hidden control and the subform will be properly 'filtered'.

Another possibility is to use the value in the hidden control as criteria for your query. Then you do not need to link the subform.

hth,
Jack
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 05:10 AM