After Update question

R

Ron Weaver

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
 
R

Ron Weaver

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??
 
R

Ron Weaver

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.
 
K

Klatuu

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.
 
R

Ron Weaver

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...
 
Top