Need to update a field on form1 when a field on form2 changes.
Posted on 2011-09-11
I have a form (form 1) that includes a field called status.
When I open form 1 a text box names StatusMsg is set to either OPEN, IN-PROGRESS, or CLOSED
The code is executed in the ON Open Event.
I use another form (Form 2) to change the status.
However, when the status is changed from form 2, the new status will not show up in form 1 unless I close form 1 and then reopen it.
I've inserted both of the below lines into my code for form 2, however, however neither works.
As always, your help is appreciated.