can't reference subform in access 2003

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!
 
D

Dan Artuso

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 .
 
M

michael c

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
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!


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top