Count Records In A Form For A Linked Table

  • Thread starter Thread starter Ella
  • Start date Start date
E

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
 
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.
 
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.
 
Back
Top