Refresh form

[IanT]

Hi.
I want to refresh a form, as I tab from a specific field on the form. So the subforms I have on the form are updated.

Can anyone help!!!!

 

[DBL]

On the OnExit event of the specific field try

Me.requery

or

Me.refresh

or

Forms![MainForm]![Subform].requery

or

Forms![MainForm]![Subform].refresh

Try each one until you get the one that works for you. Might be that you need to refresh/requery both the main form and the subform. Remember to change MainForm and Subform for your actual form/subform names!

[This message has been edited by DBL (edited 03-14-2002).]

[This message has been edited by DBL (edited 03-14-2002).]