Bizarre access form issue...

[Brad Pears]

I have a main form on which there is a subform. Depending on the menu option
selected by the user, I reset this subform's "sourceobject" to various form
names. From time to time when a "sourceobject" is reset, the form does not
display - simply a white background is present. In the past, I usually have
just gone into the form I am setting the sourceobject to and re-saved it -
and it was all good again.

Today, I am having this same problem with a particular form that was
displaying just fine on Friday. I have made NO changes to it at all but yet
only a white background is displaying today when Iam loading it! I have
tried resaving the form I am setting the sourceobject to, but alas, today
this is not solving the issue. I am unsure what to do. It appears to be some
sort of corruption for sure but I can get into design mode with no issues.

Has anyone seen this type of thing before and if so, is there a workaround
of some sort??

Frustrated!

Brad

 

[Jeff Boyce]

Brad

One thing to check might be the underlying data. Is there a chance that the
(sub-)form that did work and doesn't now has no data in relation to the
selection on the main form?

Can you go to the subform itself and get the same behavior?