Another quick question...

How to clear array so that the listbox becomes clear again when selecting a different search type? I tried RELEASE ThisForm.laSQL (error) and RELEASE laSQL (does not work). I also tried Thisform.laSQL[1,1]="" (only clears first row). What should I do?

Chuck

>>>I took a brief look into the form (didn't have time to work on it in details). I think, the main prioblem was that you have to select into thisform.laSQL and RowSource for ListBox should be thisform.laSQL, not just laSQL, because otherwise it just goes out of scope, that's why you didn't see anything in your listbox. Basically, it was the only change I made (with few small others).