Subform is refreshing when shouldnt

[thescottsman]

Hi All

I hope you can help

I have a subreport, when I go to update the report through vba code, it refreshes the form so that it is blank, hence I lose all my data.

Has anyone had this occur before in something similar?

Thanks in advamce for your help

 

[Ranman256]

Why are you updating via VBA?
Subforms allow you to update directly WITHOUT any vba.
what does this code do?