Add
Thisform.cboContactSearch.RowSource = "" before a query. See
Cannot access selected table error FAQ #18812 for details.
>But another probem still there.. "Cannot access the selected table" happens every time when I want to refill combobox.. on the first line where I do
>
Thisform.cboContactSearch.RowSourceType=0 >
>The error description not realy help me.. I have not variable with this name.. and I have not much cursors open in session.
>
>Cannot access the selected table (Error 1152)You have attempted to select a table outside the 32K work area range or are attempting to reference a file variable in a table that is not open.
>
>
--sb--