What's an alternative for DCount?

[boblarson]

Grouping queries aren't either. So if you want an updateable form you will need to use a SUBFORM (unlinked) to display the counts like you want.

 

[The_Doc_Man]

To look at the form's locking, check form properties for .RecordLocks

You can set to No Locks, All Records, or Edited Record.

The latter is misleading since the lock is actually on the page that contains the edited record. That might be multiple records, because a page is 2048 bytes.

 

[boblarson]

To look at the form's locking, check form properties for .RecordLocks

You can set to No Locks, All Records, or Edited Record.

The latter is misleading since the lock is actually on the page that contains the edited record. That might be multiple records, because a page is 2048 bytes.

Did you post to the wrong thread? It seems so given the rest of the flow.