dbTalk Databases Forums  

Form bleed through on tab control - Access 2003

comp.databases.ms-access comp.databases.ms-access


Discuss Form bleed through on tab control - Access 2003 in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Barry Edmund Wright
 
Posts: n/a

Default Form bleed through on tab control - Access 2003 - 07-05-2010 , 11:43 AM






Hi All,

I have MS Access 2003 (11.8308.8324) SP3 with hot fix 945674 & 970623
applied. There appears to be a Tab Ctl bug as explained below: has
anyone else experienced this and is there a solution.

I had a sub form on a form. Then added a tab ctl on the form and put
the sub form form on the first tab. when I opened the form in form
view I could see the sub form on the tab 0 on tab 1 as well. The sub
form did not display on tab 1 when in design view.

One further thing - I use the lines below to update the sourceobject
and recordsource for the sub form. If I don't use the
subfrmCaseProcedureDocuments.SourceObject =
"subfrmCaseProcedureDocuments" line no bleeding occurs. If I run the
database on MS Access 2007 no bleeding occurs even when I run the code
below.


vSQL = "SELECT tblCaseProcedure.strProcedure,
tblCaseProcedure.lngCaseProcedureID, etc Me!
subfrmCaseProcedureDocuments.SourceObject =
"subfrmCaseProcedureDocuments"
Form_subfrmCaseProcedureDocuments.RecordSource = vSQL
Form_subfrmCaseProcedureDocuments.Requery

Cheers,
Barry

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.