Count Records In A Form For A Linked Table

[Ella]

I am trying to show a count of open Actions in a form for each record.
My database has two tables, main table is tbDetails and my second table is
tbActionBy. They are linked by SADID with a one to many relationship. There
could also be no Actions for a Detail. Completed actions in tbActionBy are
indicated by a True checkbox, so open actions are False.

My form, frmReview has a datasheet sub form frmReviewSub and I would like to
have a field, Actions, for each record. If there are no open actions I don’t
want to display a zero.
I have tried searching the Discussion Groups without much success and I
would appreciate any help.

Thanks in advance.
Ella

 

[rm]

I am not 100% certain of your goal. I think that you want to
investigate using a query as the source for your sub form. I think
that you want a query that returns all the records with "open
actions". Next use that query as the record source for your sub form.

 

[Ella]

My Datasheet from, frmReview, shows results from my main table, tbDetails.
From my linked table, tbActionBy I would like to count the number of open
actions linked to each record in tbDetails and displayed the count for each
record in frmReview.