Solved Information from tab control form to be showed in one big message box?

[lacampeona]

Hello experts

I have one question

Let say you have a form with multiple tab controls. Is maybe now possible that with one click on some another button all the data that is in the tabs controls to be showed in one message box or another form? to be all together?

If that is possible how can I do that?
Does someone have some example to show me?
thank you

 

[CJ_London]

I cannot envision what you mean, please provide some examples of what your form looks like and what you expect to see in the message box

 

[lacampeona]

I find some example here from the forum...

 

[CJ_London]

Not good enough

where does the data come from? all one table, multiple tables? Is the view of each tab effectively a single form or a continuous form?

And what is the purpose? to print out? for a user to be able to edit? something else?

What do you want to see in the msgbox? just a list of field values and associated labels? any particular order? some note about which tab it came from?

Sorry but you are asking for a potentially complex solution and providing so little information, I would even want to suggest a way forward other than why not just do away with the tabs and display the information side by side or above and below.

 

[arnelgp]

open form frmTest001.
and see the code on the button of this form.

 

[lacampeona]

Hi
the data cames from a table and it is single form. The purpuse is to see all the data very fast. Just to click and to read the information.
In that message box i want to see all the data that comes from the tabs..
If user will click tab by tab he will lost to much seconds...I know that is strange. but one user ask me if that is possible and I say ohh i dont know...

Yes Arnel that is what I want. thank you. what else can be done with that? can i also see some subform who is the data sheet view?
but what if Have some subform inside? could that also works? and is possible that this message box can be more large?
hmmm

I will put some example if you can try. check the form -open form frmTest001.
thank you

 

[arnelgp]

i only get the First record from the subform.

 

[lacampeona]

Hi
yeees that is what I want. Very good. Thank you very much.
Yes I also get only the first record from the subform ...
I am playing here to see if I will managed to show more records...hmmmmm

 

[lacampeona]

Hi ArnelGp

I just try into the suboform to mark random record and then click the button to show the info and I think that is good. i get the subform record 5 to be showed inside the all form window so i think that is good.

Normaly users will check records in the subform one by one so I think they will be happy.
Very good again and thank you very much.

 

[lacampeona]

Hi Pat
Ohh I didnt think about that.. ok I see .
So reports with subreports is in the same way like form and subform? I never make report with subreport.
Ok I will try to do some report to see what users will prefer.
Thank you for your opinion.