Form locked when using calculated field

[mikelaccess]

Hi all,



I have a problem with a form, I can not edit the existing records or add a new one.

This problem arises when I add a calculated field in the origin of data of the form.

This calculated field is complex: Open Actions: Count (IF([Failure_Actions]![Completed]=False,1)) and I need to defined as "Expresion" in the "Total" row of the data origin.

When I put this calculated field it gets locked.

If it is just a calculated field it is ok, the problem is when I use it as "Expresion".

Any idea hoe to solve it?

Regards,
Mikel

[andy49]

Doesn't the count function in access expect a string representing something to count

eg count(*) or count [fieldname]

[JoeM]

Note that "Count" is usually used in Aggregate Queries, and Aggregate Queries are not updateable.
See: http://allenbrowne.com/ser-61.html

[mikelaccess]

Ok, thanks very much.
I will do it trouhg VBA code.

Regards!