DCount in Subform question

[BrettS]

I have a subform table on one of my forms. The fields in this subform of
importance are "Sample Count" and "# of Measurements"

The Sample Count field is an autonumber field, and I want the # of
Measurments field to be a DCount function simply counting the number of
different [Meas ID #] for the Sample Count of that row. I'm not sure how to
put this into the DCount function.

DCount("[Meas ID #]", "[Meas Data]","[Sample Count]=" & ???)

I'm not sure how to complete that to have it look at the Sample Count of
that record. Any help would be very appreciated.

Thanks,
Brett

 

[BrettS]

After reading my intial post, just for clarity I figured I should explain the
structure of my database a little further. There are basically two tiers of
data, Sample Data and Measurement data. Basically each sample has some
number of measurements. There are two different tables, [Sample Data] and
[Meas Data]. Sample Count is just a number identifying each individual
Sample and its carried over to the [Meas Data] table as well so every
Measurement is linked to its sample.

The subform is based on the [Sample Data] table. So I want the DCount
function to look at every record and count how many different [Meas ID #]
entries in the [Meas Data] table have that particular [Sample Count].

I hope that clears things up a bit.