Combine existing forms in a tab order!

[johnyjassi]

Hi all,

Is it possible to use existing form as another tab in tab control? If yes ,can you please guide me on this?
Any help will be appreciated. Thanks in advance.

 

[KenHigg]

Yes. Nothing hard. Just put the tab control on the form then put a sub-form control on the tab control and set it's source object to the other form.

 

[johnyjassi]

Hi ken,

Thanks for your reply...Its the perfect solution to my problem......But one function doesn't work properly. there is one macro that runs and choosing a value from combo box, that populate the value in text field.....but now it is not working. the path where the value is assigned is written below.

[Forms]![form1]![Com_field]

subform's name is "sbfrmform1" and tab's name is tab1 where it is inserted....could you please tell me what should I change in the path so it referes to the right path

 

[KenHigg]

Something like:

Forms!form1!sbfrmform1.form!Com_field

???

 

[johnyjassi]

No, its not working. Any other suggestions?

 

[KenHigg]

The only other thing that I can think of is the name of the subform control that you place on the tab control can be (and should be) named something different than the actual form you use as the source object. Hope that makes sense...

Anyway, you should be using the subform control name.

 

[johnyjassi]

Hi ken,

the name of the sub form is different than the form.
It is creating a problem only when I use the source form in the subform otherwise it is working fine. Any other suggestions?

 

[KenHigg]

That's about as good as I can explain it. And that may not even be the problem. Maybe somebody else can jump in...

 

[Rabbie]

This link to Bob Larson's site may help you navigate the complexities of subform referrals

 

[johnyjassi]

Thank you guys for your help. the link Rabbie gave is very good explanation of suforms and syntax. But my problem is still there and I noticed that any function that is refering to any other control on form is asking for value input like it is not regonizing the field. I am sure that it is something to do with the sub form reference. Any help will be appreciated.

Thanks!