Here’s a nice error I’ve been getting from a Microsoft Access database. I’ve been trying to access (gettit?) the data in various controls on a form, but when an Event Procedure is activated I get the above error.
In my code, I’d been retrieving the data using the command .text – this is what’s causing the error. To get round it, just remove the “.text” – it’ll still pick up the value in the control anyway.
I got the answer from here.