>Hi guys
>
>A colleague of mine is getting an error when exiting a form
>"Cannot access selected table"
>The programs and data are on his C: drive
>This error does not occur when he shares the data and I access it.
>The error stops when he disables ZoneAlarm (Security Suit v5.5)
>ZoneAlarm is configured with virus checking, but scanning has been disabled on the programs, data and temp folders.
>
>Interestingly enough, I run ZoneAlarm 5.5, but just the firewall, and AVG7 as the virus checker. I've never experienced these problems.
>
>
>Fortunately this is not happenning at client sites but I am curious to know what is going on.
>
>Any comments anyone?
>
>
>Regards
>
>Malc
I was having a similar problem and was looking for a possible solution when I saw your message. After better than 2 hrs of troubleshooting my partner and I came up with a cause and a solution. It seems that the comboboxes are similar to grids in that, if you are using the cursor as a recourdsource and then subsequently reissue the "select ..." statement at some point later, the combobox loses the link to the data. To pervent this, we cleared the combobox's recordsource before we issue the query, then reassigned the recordsource afterwards.
HTH