Prev: List Box Percentage Formatting
Next: mail
From: mmullins on 13 May 2010 22:38
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 are: 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?



--
PstBy: mmullins/mlm with humble regards to all...
From: Dirk Goldgar on 13 May 2010 22:59
"mmullins" <mmullins(a)discussions.microsoft.com> wrote in message
news:487BDC84-BDE8-4595-AD1E-0D0493672809(a)microsoft.com...
> 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 are: 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)

 | 
Pages: 1
Prev: List Box Percentage Formatting
Next: mail