Data Entry

[Guest]

Is there a way to set Data Entry to yes on a form and use a query that uses
the totals row.

My testing shows that if I remove the totals row I get a new record. If I
leave the totals row I see all records in the form.

I have set form to dynaset, data entry to yes and set filters to no. Am I
missing something or is the totals row the probelm?

 

[Dan Artuso]

Hi,
Any query that uses any of the aggregate functions will not be updateable.

 

[Guest]

Thanks Dan for confirming what I suspected.

Hi,
Any query that uses any of the aggregate functions will not be updateable.