Updating List Box

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

Guest

hi,

I have a list box with a bunch of items. I have a created a cmd button that
opens a sub form where you can add more items to this list.

My problem is that it is not updating my list box on the form
instantaneoulsy. I would like this so users can add items and choose them
from the list at that moment without having to close the form and going back
in.

Any help would be appreciated.

Thanks..
 
Is there any way to do that automatically cause I don't want the user to have
to do this everytime?

Thanks..
 
Use a close event in the subform that contains code
similar to the following:

Private Sub Form_Close()
Dim ctlList As Control
Set ctlList = Forms!frmSelectBidders!lstBidders
ctlList.Requery
End Sub

Hope this helps,
Doug Robbins - Word MVP
 
Back
Top