Access - recalc a Tabbed form Unbound textboxes
Posted on 2013-06-09
I have a multi tabbed form. One of those tabs has a form where I have several unbound textboxes. It also has an unbound textbox that adds info from all of the unbound textboxes on that form (single form).
Now then, when the user clicks a command button (ON A DIFFERENT TAB's FORM) this tab's form gets populated with info using a DAO.recordset. All of the boxes are getting their info correct but the unbound textbox where I have my subtotal doesn't automatically calculate.
On this form with the unbound boxes, I have a Private sub to add all my unbound textboxes. To execute that sub each unbound box's After_Update event calls that private sub. However, how can I get it to recalc when that form is being updated from a command click on another form?