Roll over data to new year

[terrytek]

(Macro/VBA newbie)
I have a form that displays data for tutoring pairs, one pair at a time. I have a cmd button on the form that rolls over the pair; i.e. it opens an append query that inserts the current pair's StudentID, TutorID, and the new AcademicYr in tblPairs. That macro is working fine.

I would also like this button to "reopen" the open form showing the newly updated record after the new record has been added. Is there a way to add another macro to do that as well? I tried using OpenForm but that didn't work.

Thank you!

 

[sneuberg]

Closing and reopening the form would seem to be the easier way to do this. Why didn't OpenForm work? Please show us what you tried.

If you need to show us a screen shot of a macro you may need to zip it first. You may not be allowed to upload images yet.

 

[arnelgp]

you don't need to open the form again. on the click event of the button, create an embedded macro using Requery.