Error 2110

[ZOR]

I get an error

Error: The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing the database from saving the data in the field

The error appears if I scroll through a listbox too quickly. The listbox event fills lists from queries. I dont have any macros. Any ideas. I have tried setting focus to another control after clicking the list to delay list scrolling speeds by a user, but it errors saying the setfocus cannot be done. The control is enabled okay.

Any ideas, thanks

 

[ZOR]

I isolated each query in turn, I think I had too many doevents as removing some of them has cleared the problem. I thought doevents would allow each part to deal with each section, am I wrong? Thanks

 

[Ed2020]

DoEvents frees the processor to perform other operations outside of the current routine you are in. Too many of them will have an adverse impact on your database's performance, but I've never heard of them causing error messages.

Ed Metcalfe.

Please do not feed the trolls.....

 

[ZOR]

Thanks Ed. I had a doevents command after each of four listboxes were updated via SQL statements. I took away 3 doevents and the problem went away. I put them back in and brought back the problem. So at least I have worked around it. Thanks again