Update subform sourceobject

[tekkyun]

I have a subform that has a source object based on a temp table. This temp table is re-created when users select options on the main form. The fields within my temp table also change accordingly.
How can I 'refresh' the subform to reflect the changes to the fields in the underlying table?
I have tried requery / refresh methods but all that changes is the records displayed within the existing fields. The new fields are not displayed.

 

[dhookom]

I would try code like:

   Me.subformctrl.SourceObject = Me.subformctrl.SourceObject

Duane
Hook'D on Access
MS Access MVP

 

[tekkyun]

That's it! Far too simple! I was using .recordsource and not .sourceobject to switch focus to another table whilst refreshing my temp table. I assumed that fields in form would refresh in line with recordsource change but it appears that they don't.

thanks Duane