Thread: VB "Run Time Error 3420"
09-11-06, 09:05 #1Registered User
- Join Date
- Sep 2006
Unanswered: VB "Run Time Error 3420"
I am in a bad trouble, if some one can answer me that will be very helpful.
I have never done VB before but i have been doing java & C programming.
The VB software which is given to me is producing lot of run time errors.
one of them is "Run time error 3420 , object no longer valid or set".
On debugging it takes me to the list.Requery line.
Here is the code
Set list = sys.OpenRecordset(" list querry", DB_OPEN_DYNASET)
I have tried checking for errors
if Not list Is Nothing Then
but still encountering the same run time error 3420
I just wanna get rid of this Run time error so the rest of the system should be safely running.
I will be very thankfull to you.
09-15-06, 12:31 #2Moderator
- Join Date
- Dec 2004
- Madison, WI
Does me.list.requery help? Is "list" also refering to an actual list box or some control other than what you have - perhaps the name itself is a reserved word (I think it is) and giving you problems. Does the name have to be list or can you use another name like List1?Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)