Below is the print screen:
On the Skip tab's subform the [next contact date] will state 11/8/88. Closing this form runs a macro that includes opening an update query.
The update query states IF the skip tab's subform [next contact date] = "11/8/88" then update the skip tab's subform [next...
I have a form and a subform. I run an update query and based on the value of a text box in the subform it should update a text box in the main form. The query is set to update in a macro.
When the macro runs on some accounts it updates the main form and the subform, on other accounts it just...