Checkbox on Subform

[Guest]

I want the check box to update a rate field. This rate is actually from
another subform on the main form. When I use this code it didn't populate the
rate as expected. Any ideas?

Here is my code:

Private Sub Form_frmQualifyingRateEntry_AfterUpdate()
Select Case Table.USE_Q_RATE.QUALIFYING_RATE.Value
Case True
QUALIFYING_RATE.QUALIFYING_RATE.Value =
qryQUALIFYING_RATE_CALCS3.Q_RATE.Value
Case False
QUALIFYING_RATE.QUALIFYING_RATE.Value = Null
End Select
End Sub

Thank you,

Tim

 

[Guest]

Tim,

To refer to a control on a subform from a Main form, the syntax is:

Me![Subform].Form![SubformControl]

Me![Subform] refers to the subform *control* on the main form, while
Me![Subform].Form refers to the form itself (the Source Object property of
the subform control)

To get to this same control from another subform, use the parent property to
get to the main form, and dig down from there:

=Me.[Parent].[Form]![Subform].[Form]![SubformControl]

Hope that helps.

Sprinks