Calculating Form Controls

[Guest]

I have a form calleld EVENTS with a subform called EVENTS SUBFORM. The main
form is based on a table called EVENTS and the subform is based on a table
called REGISTRATION. The Registration table has a field called CONFIRMED
which takes either a Yes or a No response. The two tables are linked by the
EVENTID field.

The problem:
I'd like to create a calculated field in the MAIN form based on the Confirm
field in the SUBFORM. I need the field to count the total number of "Yes"
responses in the Confirm field for the event on which the user is working.
I've tried everything I can think of doing but I always get the #NAME? error.

Is there a simple way to do this? Thanks.

- Sharon

 

[Rob Parker]

A possible cause of this is that you have controls on your form (and/or
subform) which have the same name as a field in the table/query which is the
recordsource. If you then try to set up an expression using such a name,
Access doesn't know if you are referring to the field or the control. So,
for example, if your Confirm field is a Yes/No field, and is displayed in a
checkbox control which is also named Confirm, you should change the name of
the control to chkConfirm.

HTH,

Rob