Updating List Box

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

 

[Guest]

Once you entered new data, simply press F9, this should update your list

 

[Guest]

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

Thanks..

 

[Doug Robbins - Word MVP]

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