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

Hi grizpatch,

You can requery the list box. I typically use a little vba like:

Me.lboNameOfControl.Requery

Refresh All from the ribbon might also work but I like vba.

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of grizpatch@twc.com <grizpatch@twc.com>
Sent: Thursday, June 4, 2020 12:57 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Updating a list box after new record entry

 

When I add a new record to my MSAccess 2010 database on a form with a List Box, the new record does not appear in the list box unless I close the form then re-open it.  Is there a way to have the new record appear in the listbox without going through that?