DCount on subForms

[jamespeters01]

Hi all,

I am trying to count the number of records in my subform which relate to the main form.

I have so far

=DCount("[SAMPLE_ID]","sample_table&quot

This works to an extent that it counts all the records within my sample_table. What I'd really like is it to count the number of records in the subform that refer the same field (ENQ NUMBER) in the main table.
Have tried a few different things, but with no success.

Any ideas ??


Thanks

 

[jebry]

Hi!

Try this:

=DCount("[SAMPLE_ID]","sample_table", "[ENQ NUMBER] = " & Forms!YourMainForm!txtEnqNumber)

You will need to use the names of your form and text box. I this code I have assumed the enq number is a number and not text. If this isn't true let me know.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[jamespeters01]

Thank you Jeff, that worked great, but I've just realised I need it slightly different still....doh !

I need the first record on the subform to say "1", then the next record to say "2" and so on. It now just says the Dcount figure. Whoops, didn't think of that !

 

[Rolliee]

why not use a me.recordcount on the subform?


rollie e