subform

[loneranger27]

Hi,

I have a form with 2 sub forms and a tabcontrol
on the main form is a subform that totals what is in the tab control. each tab control has a subform to total the information put into each of them.

I have a save button which moves the total from the tab control to the main form.

The problem is that the subform on the main form doesnt update unless I leave the form and come back to it.

Is there a way to make the subform requery from the save button in the tabcontrol.

any help is appreciated.
thanks

 

[danvlas]

Maybe...
Forms![MainFormName]![SubformName].Requery???

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[loneranger27]

I tried that and it did not work for me. Do you have any other ideas?

Thanks