Problems understanding syntax with multiple recordsets...

[AB1984]

Hi All,

I'm working on a VBA app written by a much more capable colleague and he isn't in today, without being condescending (please), could someone hazard a guess at what the following code is trying to do:

 If rs3(rs2(dataItem).Value) = rs2(dataValue) Or (IsNull(rs3(rs2(dataItem).Value)) And IsNull(rs2(dataValue))) Then
     b = True
 End If

rs3 and rs2 are recordsets, I know that much, and I understand that if the conditions are met then the variable b will be set to True, but I'm not too up on the syntax of using recordsets and it's a bit hard to work backwards.

Any guesses welcome
Cheers

 

[Norie]

How are the recordsets related?

 

[AB1984]

In what way?
It's part of a reconciliation app. So rs3 are unmatched records from the input, and rs2 is a validations file that may or may not contain a matching value in a certain column (datavalue variable points to a column that has the identifier/field name, and dataitem points to the actual value that should be in both recordsets)...at least that's what I think is going on.

I suppose I really want to know what he means when puts:

rs3(rs2(dataItem).Value)

regardless of what the data actually means, would you be able to tell what this means? or would it depend on what rs3 has been set as?

 

[Norie]

This,

rs3(rs2(dataItem).Value)

looks like it would return the value from a field in rs2 with the field name coming from a value in a record in rs3.