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

I have a button that says Add Record which runs an event procedure like this    
Private Sub AddRecord_Click()

On Error GoTo Err_AddRecord_Click

 

    DoCmd.GoToRecord , , acNewRec

 

Exit_AddRecord_Click:

    Exit Sub

 

Err_AddRecord_Click:

    MsgBox Err.Description

    Resume Exit_AddRecord_Click

 

There is maybe a control that says something like "include.."

 

Set the property to [Event Procedure] and go to the VBA code like

 

Private Sub Command4_Click()

    Me.lboNameOfListBox.Requery

End Sub

 

How do you add the new record and is it on the same form? You can add a button on your form and find the event properties in the form design. 

 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

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

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

_._,_._,_