If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
subforms-and tabs
I have a main form with tabs, each tab is a different category.example each
tab is a different credit card. on each tab I have a continous subform. I cant get the individual subforms to show the information for different credit cards. they all show the data from the first tab. any ideas how to fix this? thanks. |
#2
|
|||
|
|||
subforms-and tabs
Ron,
Sounds like you're only seeing Subform1 on all the tabs? In order to place a subform on a tab, the tab must be "selected" while the subform is "pasted"... or "installed" onto it. If you just place a subform onto a tab without first selecting that specific tab, it is considered to be on the main form... not the tab... and will show through on all your tabs. Try that first, and get back on this thread if you still have problems. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "ron csumb" wrote in message ... I have a main form with tabs, each tab is a different category.example each tab is a different credit card. on each tab I have a continous subform. I cant get the individual subforms to show the information for different credit cards. they all show the data from the first tab. any ideas how to fix this? thanks. |
#3
|
|||
|
|||
subforms-and tabs
"Al Camp" wrote: Ron, Sounds like you're only seeing Subform1 on all the tabs? In order to place a subform on a tab, the tab must be "selected" while the subform is "pasted"... or "installed" onto it. If you just place a subform onto a tab without first selecting that specific tab, it is considered to be on the main form... not the tab... and will show through on all your tabs. Try that first, and get back on this thread if you still have problems. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "ron csumb" wrote in message ... I have a main form with tabs, each tab is a different category.example each tab is a different credit card. on each tab I have a continous subform. I cant get the individual subforms to show the information for different credit cards. they all show the data from the first tab. any ideas how to fix this? thanks. I did have the tab selected when i put in the sub form. is there a way to copy the tab and paste it then connect it to the right query so I do not have to recreate the sub form each time? Or can i create one sub form and then put a filter on it so that I can use it for each tab? Hope this makes since. is f |
#4
|
|||
|
|||
subforms-and tabs
"ron csumb" wrote in message ... "Al Camp" wrote: Ron, Sounds like you're only seeing Subform1 on all the tabs? In order to place a subform on a tab, the tab must be "selected" while the subform is "pasted"... or "installed" onto it. If you just place a subform onto a tab without first selecting that specific tab, it is considered to be on the main form... not the tab... and will show through on all your tabs. Try that first, and get back on this thread if you still have problems. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "ron csumb" wrote in message ... I have a main form with tabs, each tab is a different category.example each tab is a different credit card. on each tab I have a continous subform. I cant get the individual subforms to show the information for different credit cards. they all show the data from the first tab. any ideas how to fix this? thanks. I did have the tab selected when i put in the sub form. is there a way to copy the tab and paste it then connect it to the right query so I do not have to recreate the sub form each time? Or can i create one sub form and then put a filter on it so that I can use it for each tab? Hope this makes since. is f Ron, Not sure if I understand... Yes, each subform should should have it's own query behind it, and each will need to be related to a value on the main form via the Parent-Child links. You can copy a subform, but if your individual queries contain different fields, you'll have to change all those as well. Are you saying that you're creating several subs... all with the same fields, but each filtered by some value in the associated query? If so, tell me a bit more about what your different queries are doing for those subforms. There may be another way to rethink the setup... -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions |
#5
|
|||
|
|||
subforms-and tabs
I have a main form(called credit cards) which has 5 tabs (each tab is a different credit card) on the tab is a sub form ( contiuous feed form) which shows the records for that credit card. I have a table called credit card I then created a query for each card then i created a sub form on each tab that pertains to the query for that credit card. On the main form called credit cards I have another sub form that is attached to the table credit card so that I can enter and update data for the credit cards. on the main form I also added a button to up date the records. The problem that I have is , is if there are no records in the table the fields on the sub form do not show up. when i put records in the table the first tab with the sub form works fine, but the second tab/sub form does not show the fields, even if there are records in the table and query. the query for the second tab shows the correct amount for the record. the sub form show the correct fields and amounts, but when i put the sub form on the tab is does not show the fields or amounts. hope you can understand this, I can email you the data base if that would help. "Al Camp" wrote: "ron csumb" wrote in message ... "Al Camp" wrote: Ron, Sounds like you're only seeing Subform1 on all the tabs? In order to place a subform on a tab, the tab must be "selected" while the subform is "pasted"... or "installed" onto it. If you just place a subform onto a tab without first selecting that specific tab, it is considered to be on the main form... not the tab... and will show through on all your tabs. Try that first, and get back on this thread if you still have problems. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "ron csumb" wrote in message ... I have a main form with tabs, each tab is a different category.example each tab is a different credit card. on each tab I have a continous subform. I cant get the individual subforms to show the information for different credit cards. they all show the data from the first tab. any ideas how to fix this? thanks. I did have the tab selected when i put in the sub form. is there a way to copy the tab and paste it then connect it to the right query so I do not have to recreate the sub form each time? Or can i create one sub form and then put a filter on it so that I can use it for each tab? Hope this makes since. is f Ron, Not sure if I understand... Yes, each subform should should have it's own query behind it, and each will need to be related to a value on the main form via the Parent-Child links. You can copy a subform, but if your individual queries contain different fields, you'll have to change all those as well. Are you saying that you're creating several subs... all with the same fields, but each filtered by some value in the associated query? If so, tell me a bit more about what your different queries are doing for those subforms. There may be another way to rethink the setup... -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Forms, Tabs, Subforms... Trouble Shoot Non Updateable Recordset | Roger | General Discussion | 2 | June 28th, 2005 10:47 PM |
Tabs on Tabs? | Tara Johnson | Using Forms | 2 | June 2nd, 2005 12:48 AM |
Linking subforms | Sam26 | Using Forms | 1 | May 6th, 2005 12:30 PM |
requery tabs subform data if other tabs subform changes | Chris | General Discussion | 1 | April 20th, 2005 08:34 AM |
Split subform over two tabs | GRIFFO | Using Forms | 4 | November 12th, 2004 10:02 AM |