Here is the problem:

I have a form with a listbox on the left containing a list of user names.  If you click a name in the listbox it updates the fields on the right displaying names etc. so far so good.

I have a cmd button labled "add user" (new record function).  If you click that and enter all of the info it doesn’t automatically update the list box showing the new record.  So I created an experimental button to test code.  What I am trying to do is get it to update the list box.  I have tried stuff like lbxUserList.SetFocus and an ongotfocus for the listbox such as DoCmd.Requery "lbxUserList".  If I click on the listbox the requery works great but the lbxUserList.SetFocus doesn’t seem to trigger it…….

Any help would be greatly appreciatied!

P.S.  I am very new to Access and VB, simple is good!

Thanks in advance.

Hi MikeTL.
Welcome to andreavb.com

quote:

---

If you click that and enter all of the info it doesn’t automatically update the list box showing the new record

---