After Update question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The following code is in the After Update event in a listbox . It requeries a
second listbox on the same form. How would that code read if that second
listbox was on a different form?
Private Sub List18_AfterUpdate()
Me.List20.Requery
End Sub
 
I tried that before, but I get an error Msg: Microsoft Office Access does't
allow you to use this method in the current view. What's that all about??
 
Klatuu

It only works if the other form is open. I would like to have a choice of
opening the other form. I get an error message when the other form is closed.
 
That is normal. The form does have to be open.
Look in VBA Help for the IsLoaded property. You can test for that before
you do the requery.
 
Ok
Thanks

Klatuu said:
That is normal. The form does have to be open.
Look in VBA Help for the IsLoaded property. You can test for that before
you do the requery.
Click to expand...
 
Back
Top