Recalculate

[Floyd Forbes]

Is there any way to put a command button on a main form
to recalculate the formula I have in the after update behind a text box. The
text box is in a subform on the main form.

Floyd

 

[Graham R Seach]

Floyd,

Just call the AfterUpdate event procedure.

Private Sub cmdMyButton_Click()
txtMyTextBox_AfterUpdate
End Sub

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Floyd forbes]

How do I get this to work if the text box is on a subform.