tabbed form

[Lez]

Hi Guys,

I have a Access 2007 FE connect to a remote SQL 2005 BE

I have form that has 4 tabs on it and wonder if it is possible to only load
the data for the 1st tab when it is opened that upon getting focus each tab
would then gets its relevant data.

This is simply to improve the speed of the form loading.

If anyone can suggest a method, that would be most helpful.

thank you

 

[Klatuu]

Tab controls are used to display only the selected page to the user. The
controls on the page belong to the form. Since the data is bound to the
form, it will load all the data form the form.

The only way to achive what you want is to use a subform on each page
containing the data for that page to display. The subforms can be defined
without a record source. Then in the tab control's Change event, you can put
code to set the subform's record source.

 

[Lez]

Hi Klatuu,

Many thanks for that, can you just advise how add that to the please?

Do I add the code as "DoCmd.OpenForm "myForm", acNormal on the tab control
page button? or does this code need to be put in the tab controls 'OnChange'
event?

Many thanks
Lez

 

[Klatuu]

In the Change Event.

 

[Lez]

Cheers I have found it now thanks

In the Change Event.