Help with recordset!!

[neemi]

I have two recordset. From the first recordset I am getting the description of a field and assigning it to a parameter as follows

strField = rs1![Field_Name]

I want to use the parameter to update a value in the second recordset.

The code I am using is something like:

If IsNull(Me.Controls(strField)) Then
rs2!strField = True
end if

But I know the rs2!strField doesn't work as strField is a parameter.

I have tried rs2!(strField)

But it don't work.

Does anyone know how I contruct this line of code as it is doing my help in.

Cheers in advance.

Neemi

 

[SkipVought]

Hi,

Try using a Select Case structure like this...

Select Case strField
  Case "Field1"
    rs2!Field1 = True
  Case "Field2"

...
End Select

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[neemi]

Thanks but I sorted it out... Just to share with anyone the sysntax to do what I wanted to do is:

rs2.Fields(strField)

Cheers,

Neemi