In design view subform appears as a blank white rectangle

[InFlight]

I have a button on my form to go to design view. When I change from form view to design view on a form with a subform, the subform usually appears as a blank white rectangle.

 

[MajP]

That usually means the source object is open in another subform or standalone form.

 

[InFlight]

Hi
I don't have any other form open. It is the frm_PartnershipDetails form

 

[theDBguy]

Hi. Do you have more than one subform on this form?

 

[InFlight]

Yes, I have 3 sub forms

 

[theDBguy]

Yes, I have 3 sub forms

Okay, that’s a start. Now, can you tell us the source object for each subform? I am hoping there’s a clue there.

 

[InFlight]

frm_Breeding_Cocks subform
qry_Breeding_Cocks

frm_Breeding_Hens subform
qry_Breeding_Hens

frm_PartnershipDetails_subform
qry_PartnershipDetails_subform

 

[isladogs]

Just a possibility based on another thread I helped with the other day.
See https://www.access-programmers.co.uk/forums/showthread.php?t=303155 from post #6 onwards

Do your queries have recordset type set as Dynaset (Inconsistent Updates)?
If so, make sure your subforms also are set exactly the same

 

[InFlight]

Do your queries have recordset type set as Dynaset (Inconsistent Updates)?
If so, make sure your subforms also are set exactly the same

No, all forms just Dynaset

 

[InFlight]

I have tried design view with both, with and with out. this is a pop up form.

Access 2010 with no add in's

 

[Dreamweaver]

Just tried this code on the calendar example I'm working on and worked just fine with 4 subforms


DoCmd.OpenForm Me.Name, acDesign

 

[Deleted member 147267]

Apparently is "normal" if going from form to design view when subforms are involved (when doing so via code) - but you don't say if code is doing that or closing first. I thought you had to close first but have never coded to switch to design from form view. Idea seems odd to me. Does closing first (in code) then opening in design view solve it, or do you have to do that anyway, which means no, that's not the fix?

 

[Dreamweaver]

no you don't need to close the object acess seems to handle that

 

[Dreamweaver]

give the code a try past it into the onclick of the button and comment out what you have.

 

[InFlight]

   DoCmd.Close acForm, Me.Name
    DoCmd.OpenForm Me.Name, acDesign

still no different.
Only way it works is if i close the form and right click on the Access Object and choose design view

 

[InFlight]

this is from right click on access objects

 

[Deleted member 147267]

You might have to post your db for a solution. There may be something that can be discovered that is being missed. I've tried both methods and can't replicate the problem, but that is no indication that any form tested is like yours with respect to the source for the subform control, source for the subform itself, child/parent links or anything else that can cause this. I'd also guess that there's no issue if the sf is opened on its own. It could take some investigation to figure it out.

 

[InFlight]

[Solved] In design view subform appears as a blank white rectangle

I was closing the form first. now every thing is ok

 

[JHB]

Post you database with a few sample data, that the forms are able to load.

 

[InFlight]

Hi JHB
I have attached screen shots of before and after
With your great knowledge you must know what i mean.