how to refresh subform after another subform event !

[osavioro]

i have one main form which contains 2 different subforms.
i want to refresh the second subform on first subform event.
for example in the first subform a field changes and this makes the second subform to requery.

how to make this happen ?

 

[wiltshire]

In the settings of the first subform, use the 'on change' setting to point to some VB code or a macro that requeries the second macro, and Bobs your uncle !

 

[osavioro]

re

what will be this macro ... at first i thought of this solution ... but i cannot design the macro ... in the macro builder there is a "requery" option ... but how i point it at the second subform !

 

[wiltshire]

use GOTOCONTROL to select the second subform then use REQUERY to refresh the data in it

 

[wiltshire]

sorry, don't need gotocontrol , just use REQUERY and put the name of your subform as it appears on your form, not it's actual name i.e. right click on the subform in your form's design and look at the name it's called, then use this