List Box Fails to Update - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

List Box Fails to Update

Alan Higgins

13 months ago

I have a list box on my form that will not update once the data is updated. If i click on the list box it will refresh with updated data. I have tried setting an after update event to refresh the list box and requery as well. Is there another way to initiate an automatic update on a list box?

	Sami Shamma @Reply 13 months ago
Hi Alan, please show how and where you are updating the record source of the list box.

	Sami Shamma @Reply 13 months ago
Perhaps you need to issue a me.refresh to repaint with the new data.

	Alan Higgins OP @Reply 13 months ago
I an event to the List box property and have tried other event such as "on Click" and "on enter".

	Alan Higgins OP @Reply 13 months ago

	Kevin Robertson @Reply 13 months ago
Where you change the data issue a `ListboxName.Requery` Example `Private Sub FirstName_AfterUpdate() lstSlayerNames.Requery End Sub`

	Alan Higgins OP @Reply 13 months ago
I tried this event configuration however it is the same result. Once i click in the listbox it updates Private Sub HighDiastListBx_AfterUpdate() HighDiastListBx.Requery End Sub Query name is HighDiastolicQ

	Kevin Robertson @Reply 13 months ago
You are not changing the data in the list box as you can't type directly in to it. The Requery should be in the After Update event of the field or fields you enter the data in to.

	Alan Higgins OP @Reply 13 months ago
I figured it out with your suggestion. I had the list box on my subform instead of on the main form. Once i moved it from the subform to main form it worked. Not where i wanted it but it will work. Thank you again

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View