The postings I've tried to follow haven't worked, here's my scenario. I'm using Access 2000, if that makes a difference.
I have a bound list box with job numbers in it. It's set to limit to list. I need to be able to add a new job number to the list AND the underlying table, and have it show up right away, without closing and opening the form. I have a New Job entry form I can use if I need to, but can't make it work right.

On the event which requires a new item to the list, via VBA code, add the item to the list, then requery the listbox. The added item should be visible in the listbox.