DCount function for a subform

[Beany]

Hi,

I cant seem to construct some code for my subform.

I want to basically count how many records there are in a subform....

Can someone please help? thanks

 

[Dennisk]

place a control in the form footer and use the following as the control source

=Count(*)

 

[Beany]

im confused...??!!

im using this for counting users from a table:

DCount("*", "<Asset>") --- this is in the control source of a textfield.


I need it to count the subform records??

 

[ted.martin]

Replace the * with the field name of the Unique Reference in the table and of course you don't need <> around the the table name. use [ ] instead.

 

[Beany]

ok thats fine,

DCount("User", "Asset") will search for records in a table...

I'd prefer the correct one for counting records for each user in a Subform?

thanks

 

[ted.martin]

Have you thought of using DLOOKUP but based on a query with Totals where the "User" field parameter is Group by and the Table URN is Count

 

[Beany]

I wouldnt know as i havent used DLOOKUP before..

if possible, Can you please show me an example of how a textfield counts records in a subform? (in the same form)...


thanks

 

[Beany]

ive attached my database,

on Form1, im trying to get text16 (textbox) to show the number of records in the subform.....

A user is selected from a combobox from the mainform "AssetMain" and details are shown in the Form1.

Can someone have a look?

thanks

 

[boblarson]

Beany:

No DCount is necessary. Just put a text box in the subform footer to set the count (I chose =Count([ID]), name the text box txtSubFormCount, and then put this reference in the control source of your text box on the main form:
=[Asset subform].Form!txtSubFormCount

See attached.

 

[Beany]

Cheers Boblarson.. thank you..

What if there were no records, would it automatically return 0?

 

[Beany]

Ok Boblarson,

if you remember, just recently you modified my database and placed the subform in my main form.

for some reason i cant replicate the count function to this database.... (the count function you showed me in this thread)

im moved the displaying textbox to the main form...

ive checked all spelling and it seems to be ok..but i keep getting *Name? error message


can you please have a look..youve been great help..
thanks

 

[boblarson]

Ok Boblarson,

if you remember, just recently you modified my database and placed the subform in my main form.

for some reason i cant replicate the count function to this database.... (the count function you showed me in this thread)

im moved the displaying textbox to the main form...

ive checked all spelling and it seems to be ok..but i keep getting *Name? error message


can you please have a look..youve been great help..
thanks

Here you go.

 

[Beany]

Thanks Boblarson, your amazing..

the second textbox i had was for the user name....

so ive changed it to =([User]), and it displays the user... i was just testing it, trying to self-teach