refreshing tables?

[danbo]

I have a form that has customer data. Fname, Lname, Pnumber etc. Due to record keeping requirements, once they are no longer a customer I MUST delete information about them. However, some of the information remains. therefore, I have created a page that when you click, "Delete/Copy" button a new form is brought up with the information we have to keep already in place. Once this information in confirmed you save/close that form and you're brought back to the original form. Click the Delete/copy button again and the customer is deleted.
the problem I have is that the customer that is created is put into the table but I have to hit the "refresh all" tab in order for his/her data to become available.

Question:
Is there a VBA that will cause the tables to refresh?

thanks in advance!

[June7]

Tables don't need to be refreshed. Refresh the form's recordset. In VBA this is the Refresh or Requery method. Include line in the Delete/copy button: Me.Requery