I have an access data project (MS-SQL Svr 2000 backend and MS-Access 2003
Front End) that has a sub-form based on a query view. On the sub form I have
several column's in which I have a running total on the sub-form footer.
This part works fine.
My problem is that the main form, on which the sub-form resides, I want to
display the total from the sub-form total calculation. I have tried
referencing the control on the sub form, i.e. My.Somecontrol =
Forms![formname].[controlname] but this does not work.
How do you make this works. Do I have to do something different because this
is an access project instead of an mdb?
Thanks in advance for any help!!
Mike
m charney at dunlap hospital dot org