Counting related records in a subform

  • Thread starter Thread starter Chris Saunders
  • Start date Start date
C

Chris Saunders

I have a form called Events with a subform called Event Participants
Subform.
The Events form has a field called Participants that I want to be updated to
reflect the number of related records in the subform.

The Events form is related to a table called Events which has a primary key
called EventID. This table has a one-to-many relationship with a table
called
Participants which has a foreign key called EventID.

Regards
Chris Saunders
 
Haven't seen any responses to my post.
Is it inappropriate here?

Regards
Chris Saunders
 
Hi,
No, but it's been a busy Saturday morning over here.

In general it is not a good idea to preserve the number of records in a
file.
If you have to (aircode)
NoParts:Select Count(EventId) FROM tblPart WHERE EventId = " & _
Me.EventId

Marc
 
Back
Top