Refresh active window

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have some subforms within a main form. When I make a
change to the combobox on the main form, I have to click
to one of the subforms in order for the data to refresh.
It there a way to refresh the window without have to move
to another form.

Thanks,
John
 
Would putting the refresh command within the
COMBOBOXNAME_BeforeUpdate or COMBOBOXNAME_AfterUpdate work?

Me.Requery

or

Forms![FORMNAME].Requery
 
-----Original Message-----
I have some subforms within a main form. When I make a
change to the combobox on the main form, I have to click
to one of the subforms in order for the data to refresh.
It there a way to refresh the window without have to move
to another form.

Thanks,
John
.
Click to expand...
Hi John,

have you tried using either me.refresh or me.recalc in the
combobox_AfterUpdate() ?

Luck
Jonathan
 
Back
Top