You must use "safe select".
http://fox.wikis.com/wc.dll?Wiki~GridSafeSelect.
>Hi Rich,
>You need to keep (.rowsource) used
>
>Thank you Thierry. I really appreciate it. I'll have to look for a different tactic.
>Rich
>
>
>>I keep getting the following message...
>>"cannot access the selected table".... and it points to the ROWSOURCE property of the listbox.
>>
>>I don't get it. The help section says to set the rowsource='' before the query and set it back to its original setting afterward. At least that's what it sounds like its saying. Some of these help messages are really cryptic.
>>Anyway, I've tried all sorts of things but obviously not the right one.
>>
>>Any ideas? Sure could use some help. I'm out of ideas.
>>
>>Thanks,
>>Rich Murillo