DoMenuItem

[ddrew]

My code is throwing an error on the DoCmd. I copied it from an old database that I built but Im now using Access 2016. Haven't done access for a while so Im out of touch. Has it changed?

DoCmd.DoMenuItem acFormBar, acrecordmenu, 5, , acMenuVer70
    Me.List127.Requery

 

[Ranman256]

You don't need all that....just use
List127.requery.

Domenuitem is for commands in the access menu.

 

[sneuberg]

http://access.mvps.org/access/RunCommand/domenuitem.htm might help

 

[ddrew]

You don't need all that....just use
List127.requery.

Domenuitem is for commands in the access menu.

Thats what I thought, but the list isn't updating.

This what I was using but as I say I was expecting the list to update as soon as I finished but it only updates when I select an item in the list box!

Private Sub ChristianName_BeforeUpdate(Cancel As Integer)
    Me.List127.Requery
End Sub