tab control link

[Guest]

Form1 is client form.
Form2 is job form.
Form3 is labor form.

Form2 is on TabControl and is a subform of Form1. They are linked by
ClientID and this returns all jobs for viewed client.

Form3 is (presently) a subform of Form2. They are linked by InvNum and
returns labor for viewed invoice of viewed client.

I wish to move Form3 to its own tab but still be linked to the InvNum of
Form2 as viewed, so that when the user uses Navigation Buttons to move
through the viewed client's invoices, they can see a viewed invoice's labor
by clicking on a tab.

Is there a way to accomplish this?

 

[Al Campagna]

Chris,
Any object on a tab page is still considered to be on the Main form. The Tab really
doesn't require any special addressing.
If Field1 were on the Main form, the "address" would be Forms!frmMAin!Field1
If Field1 were on Page2 of a Tab control it's address would also be...
Forms!frmMAin!Field1
If your Job and Labor subs work (synch poperly) now, they will still work when LaborSub
is placed on TabPage2.

Personally, I would try my best to place both subforms on the same tab, so... as you
browse JobSub you see the LaborSub records without having to acces TabPage2. Maybe even
an "abbreviated" form of LaborSub that just shows just the critical labor info that you
most often want to see.
Then, on TabPage2, use your "complete" LaborSub with all the labor info, that you could
access when you really need to see the labor "details"
Just a suggestion....
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

Thanks Al.

Room was my issue and I never considered splitting into entry/edit and view.
I just didn't want to add subforms ad infinitum.

That's what I shall do.

--
Thanks for your help,
Chris

Chris,
Any object on a tab page is still considered to be on the Main form. The Tab really
doesn't require any special addressing.
If Field1 were on the Main form, the "address" would be Forms!frmMAin!Field1
If Field1 were on Page2 of a Tab control it's address would also be...
Forms!frmMAin!Field1
If your Job and Labor subs work (synch poperly) now, they will still work when LaborSub
is placed on TabPage2.

Personally, I would try my best to place both subforms on the same tab, so... as you
browse JobSub you see the LaborSub records without having to acces TabPage2. Maybe even
an "abbreviated" form of LaborSub that just shows just the critical labor info that you
most often want to see.
Then, on TabPage2, use your "complete" LaborSub with all the labor info, that you could
access when you really need to see the labor "details"
Just a suggestion....
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."