refresh form from subform (1 Viewer)

[RpbertS]

hi,
I have a subform on a form and I'd like to refresh the form from within the subform whenver tab is pressed this may not be possible to do on tab if its not can it be done on keypress? or something similar to that?

thanks for the time,
Rpb

 

[Mitch]

Just an idea but you could put the forms![frmFormName].Refresh command into the got focus of each item in the subform then whenever tab (ie change field is pressed) the new field gets the focus and the refresh action is carried out.

Mitch.