New field causes error

[lrfcbabe]

When I associate a Data field in access to a checkbox in VB6
I start getting errors when I run my query and for every record in the query. If I remove the association, everything works and I do not get the error "System Error &H80004005 (-2147467259). Unspecified error". I use other checkboxes and do not have problem with them. I have about 80 fields in my database with almost 1000 records it's not very big but growing daily. Is it VB or is it Access?
Or is it me?

Thanks

 

[tlbroadbent]

I'm unclear what you mean by "associate a Data field in access to a checkbox in VB6". Could you post a code sample (VB) and the query? Also post a sample of the output you get.

Thanks, Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin