Counting related records in a subform

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
 
C

Chris Saunders

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

Regards
Chris Saunders
 
M

Marc

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Choose a record without making a subform 6
Choose Record from a list in a Subform 4
Comparing data from a subform and form 1
Suggestion for Structural Approach? 3
multiple recordset for forms 5
Subform Filter 1
Calculating Form Controls 1
Out of Control Combo Boxes 1

Top