Blank Form View

[Charles G via AccessMonster.com]

Allow Additions =True
Query has records
Report is correct.
However, my Form View is now blank.

In my query under design view I checked the Totals under View. I changed a
couple of fields to show Account # totals (SUM) in my report and now my Form
is Blank. If I uncheck my Totals on the View menu, my Form is back.

-Charles-

 

[Ken Snell [MVP]]

I'm betting that the form's Data Entry property is set to Yes. A totals
query is an nonupdatable query, and cannot be used for adding new records.
If your form is set up to only add new records (Data Entry is Yes), then it
cannot display any record for you to edit/enter, and thus no controls show
on the form.

 

[Charles G via AccessMonster.com]

That's correct, my Form is set up for data entry = true.

Thanks,

-Charles-