Automatically update Subform control

[Fozi]

Hi

On my Parent form I have the Control [TotalHrs] which contains a numeric value. A subform called [FRM_Flexi] has a control called [FlexiTot].

What is want is for [FlexiTot] to automatically change according to the change in [TotHrs].

I've tried putting in Me.FlexiTot.Requery in the [TotHrs] AfterUpdate and On Change properties but to no avail.

The only time the [FlexiTot] control shows the updated value is if I exit and re-enter the Parent Form.

Thanks
Fozi

 

[JANR]

You could try this in the After_Update of TotalHrs:

Me.FRM_Flexi.Form.FlexiTot.Requery

JR

 

[Fozi]

Thanks Jan but unfortunately it didn't seem to make a difference. Will try it with the On Change property

Thanks
Fozi

 

[JANR]

Will try it with the On Change property

No use the after_update but change "Requery" to another methode. Requery will work on combobox/listbox but i don't think it works on textboxes.

Try Recalc or perhaps refresh

JR