Re: [MSAccessProfessionals] Updating a list box after new record entry

"However, that won't requery a combo box. To do that, you can put this code on the Form AfterUpdate event:

Me.combo_controlname.requery

WHERE

combo_controlname is the NAME property of the combo box (or listbox)

kind regards,
crystal"

 

Crystal,
I put the following code in the After Update of the Form

Private Sub Form_AfterUpdate()

Me.listbox_list42.Requery

End Sub

It did not requery the ListBox to show the new record.  That only happens when I close the form and re-open it.

Russ

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115554) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_