Is there a way to re-open forms after a synchronize?
use the docmd.openform function.
If you need to know which forms were open, loop through the forms collection before you start the syncronisation
e.g.
Code:
dim s as string
dim frm as form
dim a() as string
dim i as integer
'one method
Do While Forms.Count > 0
s = "," & Forms(0).Name & s
DoCmd.Close acForm, Forms(0).Name 'to make sure the form is closed
Loop
'another method to just record names
'For Each frm In Forms
' s = "," & frm.Name & s
'Next frm
'sync code here
a=split(s,",")
for i=1 to ubound(a)
docmd.openform a(i)
next i