When you need to count records in an Access form, try the Count() function.

A missing value can lead to confusion by returning error values. But a properly used Nz() function can turn an error message into an understandable and expected value.