refresh subform data ...

[YvesX54]

Hi,

Consider that you have a main form 'Project' and attached to that a subform 'Tasks'. I created a button on my main form 'Insert default tasks' so when a user clicks the button, i trigger some code to programmtorically insert the records in the tables Tasks. I never leave the forms environment. How can i refresh the subform data because the subform is not aware of the new data that was entered ?

Greetzzz
Yves

 

[Rich]

Add
ControlName.Requery to the buttons event procedure

 

[latex88]

Rich,

I have a similar situation, except that I want to refresh a subform within a form. The data in the subform is updated through some event procedure. I know the subform, by itself, gets updated. However, the subform within a form is not updated. I tried refreshing the form containing the subform, but it does not work. I tried to refresh and requery the control name of the subform, and no luck.

The only way the subform is updated within the form that contain it is when I manually either go to the Deign View first then back to the Form View, or close the form and reopen it. So I thought maybe I'll just put that action in the code, closing and opening it in a event procedure, but that doesn't work.

Can you help?

 

[YvesX54]

no luck at all !!

at the end of the insert script, i inserted some code to jump to some record and jump back to the record where the insertion took place, but no refresh of the subform data !

still trying to find a solution.

regards
Yves