>I have a procedure that is triggered by clicking on various radio buttons. This procedure issues a SQL Select with the resulting data being placed in a table. note: (This table already exists as it was created by an earlier SQL Select). When I issue the refresh command for the list box that displays the information in the table, I get the error message "unable to access selected table". Does anyone know how to resolve this?
Set the listbox's rowsource to "" before requerying, and then set it back after you're done. Even though the structure of table might not have changed, you can't fool the listbox; it knows you messed with it's rowsource, and it's upset.
Erik Moore
Clientelligence