>I have a form with a listbox control on it that is used to select a record that is then displayed on another form. When I return to the original form I rebuild the table that is used for the listbox (might have new entries etc.)
>
>Sometimes, upon returning to the orignial form, I get the error "Cannot access selected table" and the listbox disappears. The only way I have found to rebuild the listbox table without getting this error is to SELECT into a temporary table, zap the original listbox table, and then append from the temporary table.
>
>Does anyone know how to handle this in a better way?
>
Use a cursor that was created with a SELECT for the rowsource of the listbox instead. RowSourceType = 2 (alias) or 6 (fields)
Insanity: Doing the same thing over and over and expecting different results.