When my form loads, controls in the details section don't

[pompeyjim]

Whenever I start my Access 2000, one of the forms in a database I am
designing loads the controls in the Header and Footer all right but
absolutely nothing loads in the detail section, not even the SubForm. Up
until yesterday the form and all controls loaded perfectly. All other forms
in the database load fine.

 

[Allen Browne]

The Detail section of your form goes completely blank if both:
a) there are no records to load, and
b) no new records can be added.

You can produce that condition with any form by setting it's Data Entry
property to Yes, and AllowAdditions to No. There are lots of other ways to
produce that also.

 

[pompeyjim]

Thanks for your reply. I looked in the property sheet and noticed that the
Recordset Type was set to Snapshot so I changed it back to Dynaset and
everything's fine now.