Requery (or Refresh) data on an inactive form

[Adam]

Hi,

When using the requery command in VB code, is it possible
to requery a form's data when it is not the current active
form?

You see, a command button on the 1st form opens a 2nd
form. 1st form is inactive, 2nd form is active. When I
activate a command button on the 2nd form, it will cause
change to a control on the 1st form, but that change is
not evident unless I close the 2nd form down (since it is
still the active form) and requery the 1st form.

I am trying to write code that will requery (or refresh)
the data showing on the 1st form without having to close
the 2nd form down.

Can you please help?

Many thanks

Adam

 

[Bas Cost Budde]

Forms(yourformname).requery should do.

Hi,

When using the requery command in VB code, is it possible
to requery a form's data when it is not the current active
form?