subforms-and tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Al Camp said:
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
Click to expand...
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 csumb said:
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
Click to expand...

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...
 
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.
 
Back
Top