Screen White-out (1 Viewer)

[JACKSON]

Hi
We have had some problems recently where certain sub-forms on a front-end database completely "whited-out". There was just a blank white form where the subform should be. Once I was able to compact & repair the backend file, and the problem was fixed, another time I wasn't so lucky, and needed to manually transfer data to a new database. Any thoughts on what might cause this ??

Thanks

Jackson

 

[AngelicGuardian]

I have also experienced similiar problems.. I normally find out it is a problem with that subform or subreport. How I have fixed it is open the subform or subreport and look for any errors in opening if you don't get any goto the design view for that sub form or sub report and Look at where it gets it's data from that is normally where the error lies ( in the SELECT function call).