can't reference subform in access 2003

  • Thread starter Thread starter michael c
  • Start date Start date
M

michael c

Hi. I was using Access 2002 a few days ago and have
switched to 03. One of my forms used to successfully
reference a value on one of its subforms but it won't do
it in 03. I have no idea why.

Specifically, I have a control on my main form with a
function that calculates the workdays in the quarter. It
then is supposed to subtract a value that's in the
AdjustmentThisQuarter control on the
frmWorkingDaysAdjustments subform:

=Work_Days([FirstDayOfQuarter],[LastDayOfQuarter])-(Forms!
Dashboard!frmWorkingDaysAdjustments!AdjustmentThisQuarter)

No dice. Any thougths? THANKS!
 
Hi,
Here is the syntax to access a control on a subform:
Forms!mainFormName!nameOfSubformControl.Form!nameOfControl

Now, the name of your subform control may or may not be the same
as the subform .
 
Thanks Dan! I'll give that try.
-----Original Message-----
Hi,
Here is the syntax to access a control on a subform:
Forms!mainFormName!nameOfSubformControl.Form!nameOfControl

Now, the name of your subform control may or may not be the same
as the subform .

--
HTH
Dan Artuso, Access MVP


"michael c" <[email protected]> wrote
Click to expand...
in message news:[email protected]...
Hi. I was using Access 2002 a few days ago and have
switched to 03. One of my forms used to successfully
reference a value on one of its subforms but it won't do
it in 03. I have no idea why.

Specifically, I have a control on my main form with a
function that calculates the workdays in the quarter. It
then is supposed to subtract a value that's in the
AdjustmentThisQuarter control on the
frmWorkingDaysAdjustments subform:

=Work_Days([FirstDayOfQuarter],[LastDayOfQuarter])- (Forms!
Dashboard!frmWorkingDaysAdjustments! AdjustmentThisQuarter)

No dice. Any thougths? THANKS!
Click to expand...


.
Click to expand...
 
Back
Top