Display Tables record number on the main form

[mansied]

Hello
I have a Database with 4 tables . How can I show the number of the records on the Main form?
When I create put "=Count([table1]! [primayKey1]) " for one table works .but when I add other tables it shows #Error for all even the first one ?
How can I show all tables total records on the main page?
Thank you

 

[Ranman256]

Put 4 list boxes on the form.
Under each list put a textbox,w the source:
=listbox.listcount-1

 

[mansied]

Put 4 list boxes on the form.
Under each list put a textbox,w the source:
=listbox.listcount-1

How do I assign the textbox to each table?I am not sure I got your idea .could you show me with a sample ?

 

[mansied]

 

[mansied]

 

[MajP]

How about the control source equal
=Dcount("*","TableName")

 

[mansied]

How about the control source equal
=Dcount("*","TableName")

Yes it worked. Thanks a lot