Yep, me too.
I think the error arises once you've loaded the form, as the debugger stops at the line:-
cnCh5.Open strConnection
as (I think) the connection is already open ?
Also, I found that I couln't add or amend records to the table using the form as "This Recordset is not updatable". You might also get the message that Access has locked the table. I tried changing the LockType property on the rcordset to adLockPessimistic but still had the same problem.
Glad it's not just me!
Phil
|