Count players records for each club

[mitch97144]

I have a problem displaying the total count of players signed to a club.

I have two tables (tblclubs - PK=clubname)&(tblPlayers - PK=regid).

A form has been generated to display each club. Within the form i want to total the number of players
signed. At present i have tried to use DCOUNT with no joy and i have created a query which does work ok. The problem is that when i assign the query to the text box it displays #NAME##?.

I have attahced a table layout example and a copy of the form.

Please help

 

[llkhoutx]

You can't

assign the query to the text box

Count the records using a recordsetclone on the OnCurrent event.

dim rsc as dao.recordset
set rsc=me.recorsetclone
me!Count = rsc.recordcount
rsc.close
set rsc=nothing