Count Records in Form

Tropez

New Member
Joined
Apr 19, 2004
Messages
35
Greetings all, I need some assistance with updating a form to show a record count.

I have a form that displays a listbox with names in it, along with a sub-form that displays a query linked to the name selected from that first list.

I need to add a text field (or something similar) on the main form that displays the number of null records from the sub-form.

Ken
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,432
Hi Ken

I can't quite visualise what you are referring to, so can you elaborate on this? Is this a main form / sub form set up where you want to count the number of items from the main form where there are no records in the subform?

If so then this could be done using the DCount function in an unbound text box in your main form (in conjunction with another query that counts the 'sub' records for each 'main' record).

Andrew
 

Watch MrExcel Video

Forum statistics

Threads
1,118,330
Messages
5,571,570
Members
412,406
Latest member
DutchMonkey
Top