Update list on form 1

[3699wat]

Need help with setting a procedure to update a list on a form after entering data and clicking on the ADD RECORD button I created to update the underlying table. The fields clear after clicking to start adding a new record but the listbox is not updated unless I close the form and reopen it.

 

[essnrv]

After Inserting the record Requery the list control.
ME![List Box Name].Requery
Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!

 

[GHolden]

Try

ListBox.Requery

There are two ways to write error-free programs; only the third one works.

 

[3699wat]

Sorry
But were exactly do you put that code?

 

[essnrv]

In your ADD RECORD button click event Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!