Refresh form data from button on Subform 1 for Subform 2 and 3

[freespiritcherishes]

Hi all

I have a main form with 3 subforms. Subform 1 being the biggest form. I have a button on it that refreshes the form data of Subform one, but how do i get it to refresh the form data of subforms 2 & 3. I used the Docmd.repaintobject cmd referring to the forms but i just keep getting an error. Does anyone know how to do it?

kindest regards
freespirit

 

[Prog76]

Have you tried Me.Requery or SubForm3.Requery where SubForm3 is the name of that subform?

 

[freespiritcherishes]

hi Prog!

do i put that on the onclick event of my button or the oncurrent event of the subform in question?

Thanks for replying

regards
donna
aka freespirit

 

[Prog76]

Try the onclick event of the button.