While designing a form, the Form View goes blank, Why?

P

Pheecaitdj

This happened while designing a form. I finally noticed I was using too many
tables, now it is happening while designing a report. I would like to know
what causes this so I can learn to avoid it.
 
J

John W. Vinson

This happened while designing a form. I finally noticed I was using too many
tables, now it is happening while designing a report. I would like to know
what causes this so I can learn to avoid it.
Click to expand...

A Form based on a query which a) returns no records and b) is not updateable
will be just blank - not even the controls visible. Be sure that your tables
are correctly related and that your Query has appropriate joins. Ordinarily
one would not base a Form on a multitable query - use a Form (for the "one"
side table of a relationship) with Subforms (for the "many") instead.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with data displaying in form and layout view 2
Auto-Poulate a Value in a Table 6
Access 2002 Form object 2
Information in a table does not appear on the form 1
Adding Tabs While Designing A Form 4
Designing and Access Questions 6
Slow Report Design Mode 1
Help Designing Outlook Form 0

Top