calculation in a subform does not display

[lynn atkinson]

I have a DCount calculation which displays correctly when I view a form.
However when I open the main form which contains it as a subform, the
calculation field displays#Name?
What do I hae to do on the subform to get it to display the calculation
correctly?

The dCount statement is

=DCount("[status]","bookings","[event ID]=" &
[Forms]![multiplebookingsubfrm]![event ID] & "AND [status] IN
('booked','provisional')")

 

[Van T. Dinh]

Try:

= DCount("[status]","bookings", "[event ID]=" &
[Forms]![MainForm]![SubFormControl].Form![event ID] &
" AND [status] IN ('booked','provisional')" )

Replace [MainForm] and [SubFormControl] with proper names from your set-up.
Note that SubFormCONTROL name may be different from the name of the Form
being used as the Subform (more accuarately, being used as the SourceObject
of the SubformControl).

 

[lynn atkinson]

Thanks for the reply.
However, I have lost the plot! What subformCONTROL am I referring to in your
statement?

Try:

= DCount("[status]","bookings", "[event ID]=" &
[Forms]![MainForm]![SubFormControl].Form![event ID] &
" AND [status] IN ('booked','provisional')" )

Replace [MainForm] and [SubFormControl] with proper names from your set-up.
Note that SubFormCONTROL name may be different from the name of the Form
being used as the Subform (more accuarately, being used as the SourceObject
of the SubformControl).

--
HTH
Van T. Dinh
MVP (Access)

I have a DCount calculation which displays correctly when I view a form.
However when I open the main form which contains it as a subform, the
calculation field displays#Name?
What do I hae to do on the subform to get it to display the calculation
correctly?

The dCount statement is

=DCount("[status]","bookings","[event ID]=" &
[Forms]![multiplebookingsubfrm]![event ID] & "AND [status] IN
('booked','provisional')")

 

[Van T. Dinh]

Open the MainForm in DesignView. Open the Properties window. Click once on
the Subform. Make sure the title of the Properties window shows "Subform /
SubReport ..." and the name in the Properties window is the name of the
SubformControl.