I've got a list box that has about 6-7 columns with information, pulled from a table. When you click on a row in the list box it displays all the information in a series of text boxes, so that the information can be edited. I've got an add and delete button, so you can select a row in the listbox, then delete it; or enter information in the listboxes, then click the add button and add the information to the table.
The buttons work fine with regard to making the changed so the table. Now I'm looking for a way to essentially refresh the listbox when the button is pressed to represent the new table information. I'm trying to use the .Requery method, but it doesn't seem to work.
Now, if I delete a line, then click on another line, it will show "#deleted" (or something to that effect) for each item in the row; but it won't clear it away. Any help for how to get the listbox to refresh would be greatly appreciated. Thank you in advanace.