Originally Posted by
June7
You just want to display the aggregate calc, not save to field in table? Options:
1. form RecordSource that joins the query with other table, join type "Include all records from {primary table} and only those records from {query name} that match" then bind textbox to the count field, set properties Locked Yes and TabStop No, however, been a while since I tried this, the resulting dataset might not be editable
2. DLookup() expression in textbox
3. listbox or combobox with the query as RowSource and filtered to some ID on the form