ADO Object Variable not set

[neepshed]

Hi.

I have a procedure that has a list of ids in a recordset. I compare each of these ids against an external database table.

However if an id does not exist in the external table i get the error 91 object variable not set error.

If rsWellList.Fields("IDWell").Value = moWVIO.Well(CStr(wellidx)).IDWell.Value Then

it's the right hand side of the condition above that is empty. Anyone any thoughts on how I can work around this?

 

[neepshed]

I guess I want to know how do I check if the right hand side of the condition is not set?

 

[HarleyQuinn]

You could filter your referenc e to the db table to exclude NULL's in that field.

It might be worth providing a bit more information about how you're getting your information from the db table to allow us to help you a bit more.

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.