Unanswered: I need to have my subform show updated table
I am using an unbound form to populate a table (tblTheGoods). I also wanted the user to be able to see the table they are updating in a subform. Thats easy enough, except when they submit the data from the main form you have to close and reopen the form to see the change. I already have an OnClick event built into the submit button, would it be easy to refresh my subform and corresponding table in the same block of code? or would I make another block.. I am new to this. My mainform is Unbound, but the subform is bound. Here is the code I use to update my unbound table.. would this be the spot I would tell it to refresh the subform OnClick?