requery hell

[Ian]

I have a form in DS view that I need to requery when focus shifts to it.
Useres pop between this form and another with data constantly changing as
they update dates. I need the form to refresh when focus shifs back to it.

In the OnGotFocus event box I've put the code:

Private Sub Form_GotFocus()
Me.Frm_ICCallBack.Requery
End Sub

Ken helped me before with a similiar combobox problem but I can't do the
same to a form. Any help appreciated. thx. Ian.

 

[John W. Vinson]

In the OnGotFocus event box I've put the code:

Private Sub Form_GotFocus()
Me.Frm_ICCallBack.Requery
End Sub

Ken helped me before with a similiar combobox problem but I can't do the
same to a form. Any help appreciated. thx. Ian.

Try using the Activate event of the form instead. The form doesn't actually
get the focus itself (usually) - only the control on the form.

 

[Ian]

1 hour of playing solved in 1 minute of good advice. Thank you.