Full Access vs Runtime Module

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a master (FrmPTS_Edit) form that contains 3 subforms and one text box
(tpoc_count). I use tpoc_count to count the number of employees listed in
the 3 subforms combined. (each subform contains a list of employees from
different list that will support the project represented by the master form's
record)

tpoc_count control source reads as follows:

=Forms!FrmPTS_Edit!SFrm_POC_Client.Form.Recordset.RecordCount+Forms!FrmPTS_Edit!SFrm_POC_TDT.Form.Recordset.RecordCount+Forms!FrmPTS_Edit!SFrm_POC_Others.Form.Recordset.RecordCount

This works great in the full version of Access, however on our machines
running Access Runtime, tpoc_count does not display the total number, but
rather the #Name error. We are running Access 2003 Runtime version
11.0.7969.0

Thanks in advance

Chris
 
One more thing I should add, the 3 subforms and teh text box are all
contained on one of the TABs of the master form called POCs.
 
Back
Top