OK. I have a form that contains a list box. The row source type is 3 - SQL statement and the row source contains the select statement I want to use to populate the list box. The first run it's OK. The problem is when data changes and I run the listbox.requery method it does not reload the data in the listbox. I am actually building the select statement in a var and placing it in the row source. This method works great for grids, which I am about to change to from my listbox, allowing programatically created select statements to populate a grid, but I just can't get the list box to reload the data. I am going to use a grid in place of the list box now but it still bugs me that I couldn't get the listbox to do what I wanted. Any ideas?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only