I have 8 tables which I need to count the records in, I want to display results of the count on a form, I have a method which seems very long winded and I am sure there will be an easy solution in vb that one of you helpful people will advise ?

On a Form when opening I need;

Table 1 = "records"
Table 2 = "records"
Table 3 = "records"
Table 4 = "records"
Table 5 = "records"
Table 6 = "records"
Table 7 = "records"
Table 8 = "records"

Any advise apriciated.

You could use the DCount function

Thanks!! Just need that kick in the right direction