"mmullins" wrote in message
...
Hello:
As part of a review assignment, I have been tasked with adding a
calculated
field to a form that will count the number of items listed in the
associated
subform. The subform is based on the table "tblProduct", and is a subform
named "frmProductSubform". The Parent table is named "tblCompany".
The tables are related by ProductID, and CustomerID fields. The fields
included in the subform a ProductID, ProductType, Price, and Unit.
I am trying to create a calculated field based on the subform that will
count the number of line items in the subform for the Parent table
Customer
record. I have added a text field to the Parent table's detail section
named
"Number of Products", and attempted to build an expression
"=Count([ProductID])" to count the records in the related subform, but all
I
get is "error".
What am I missing here?
Try setting the ControlSource of your [Number of Products] text box to:
=[frmProductSubform].[Form].[Recordset].[RecordCount]
Note that this assumes that the subform control (on the main form) is
actually named "frmProductSubform" -- it may not be, even if it is
displaying the form that has that name.
--
Dirk Goldgar, MS Access MVP
Access tips:
www.datagnostics.com/tips.html
(please reply to the newsgroup)