Check box on tab with subform

[mleinss]

Hi
I am working on converting a Access 2000 database to Access 2007..I was able to solve most of the problems, I have one left
I have a form (QuoteDetFrm03) with a tab control (tabCtl259) with 7 tabs
One of the tabs( Tab Page 261)has a subform (QuoteDetBankFrm01) where the user has the option of using a check a box
When the box is checked an events runs a function to delete some records then append other records to a table.
After the function runs the event adds data to the record.
My problem is the subform will not refresh, delete shows in the subform where the records were deleted, but the new records to not show. If I hit F9 or close the subform the proper information is displayed on the subform.

I have seen similar problems on the form, but their solutions do not solve my problem

Thanks

 

[vbaInet]

Look into the Requery action.

 

[mleinss]

That was it, the old version did not need a requery statement after the execute statement

thanks

 

[vbaInet]

You're welcome!