Form Tab Controls

[f5snopro]

I'm working on a short project in which I have a form based on a query. When you open the form, the query is kicked off and you are asked for an ID number. The query runs and the info is displayed.

What I am trying to do is add tabs to that form where, based on the input ID, the relevant data is displayed. Problem is, there are 700+ values which will be on various tabs and I cannot add them to the query. How can I link the ID place in the query to those tabs so relevant attributes display?

Example: Application Database - The user is asked for an app ID and after it is input the query runs...App name, Id, owner, etc are displayed on the main form from the querey. Subsequent tabs have check boxes for types of components that may be used in conjunction with it (i.e. Internet Explorer, Netscape, Java, etc.)

Any help is appreciated. Thanks!

 

[TCVance]

If I understand your question, you want the ID number to always show while you go through the different tabs.

If this is the case you might try having the important data (ID, Name, etc..) in a header section and set the tabs up in the detail section.

Hope this helps and I understood your question.

 

[annsolomon]

I'm not sure why you want to use the tab control. Assuming that your query is based on two tables related by the AppID, can't you set this up as a form/subform and link the two forms based on the AppID? That way, your subform will show only those records related to the primary key on the main form. Ann

 

[f5snopro]

TCVance...

You got part of it. I would like to have the App ID and Name in the Header section, then subsequent tabs for the attributes of the application. The problem is I don't know how to link the 6 tables I have so when I open the form and it runs the query, those other 5 tables which store the values know which app id I'm talking about. Don't know if I'm explaining correctly.

I can't query the 6 tables, 700+ records at one time in a single query. So I'm trying to figure out how I can get the other 5 tables (attribute tables) to link up to the main table which shows App name, id, owner, etc.

 

[f5snopro]

Ann,

I tried the subform idea and it works decently, but I would like to try and have check boxes for values instead of rows and colums. For instance:

Plumtree [] ASP []
I.E. [] C++ []


In a form style so users can just check the box if they use it. Hope that helps to clarify.

 

[f5snopro]

I figured it out! Woo hoo! Thanks for your help.