Updating subform control based on another control value in the SAME subform.

  • Thread starter Thread starter Rob W
  • Start date Start date
R

Rob W

Greetings,

Calculated result is a field that is updated based on the two other fields,
this is done in the subforms query and as based on an expression cannot be
overtyped (which is good!).

All I want to do is once a value appears in the field is to populate another
field (see code below).

Runs without errors but see no results. Any help would be appreciated.

Private Sub CalculatedResult_AfterUpdate()

Dim CResult As Integer
CResult = Me.CalculatedResult.Value
Me.ActualResult.Value = CResult
Me.ActualResult.Requery

End Sub

Thanks
Rob
 

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

Similar Threads

Parameter Value error in a Subform 0
Link subform ID control 3
Subform Reference 2
Hide Controls on Subform 2
Access Reference Subform's Control 0
Refreshing main form from the subform 1
re-using a subform 4
Reference to subform control from another subform control 1

Back
Top