Error 3265 - Again!

[thejad]

Hi,

I looked up all I could read up on the error, and still can't make heads or tails of what I am doing wrong.

My goal is to be able to update a series of fields for a specific record using a loop. As such my field name must be a variable.

I have shortened the code to the particular area where the error arises. I have declared all my variables, and field names referenced by the variable match those in the table.

Dim fld As DAO.field
Set fld = updatetable(0)
 
                x = 0
                For x = 0 To length
                    If e(x) > 0 Then
                        xstr = CStr(x)
                        .Edit
                        strfldnm = "Error" & xstr
                        fld = strfldnm
                        ![fld(0)] = True
                        .Update
                    End If
                Next x

If anyone could help, it would be greatly apprecaited. If you need all the code, I'll gladly post it.

Thanks

[thejad]

Found the answers in the tutorials - i needed to call it as:

updatetable(fld) = True

rather than

![fld(0)] = True

I can't say that I totally understand, but it works!

Thanks

Hi,

I looked up all I could read up on the error, and still can't make heads or tails of what I am doing wrong.

My goal is to be able to update a series of fields for a specific record using a loop. As such my field name must be a variable.

I have shortened the code to the particular area where the error arises. I have declared all my variables, and field names referenced by the variable match those in the table.

Dim fld As DAO.field
Set fld = updatetable(0)
 
                x = 0
                For x = 0 To length
                    If e(x) > 0 Then
                        xstr = CStr(x)
                        .Edit
                        strfldnm = "Error" & xstr
                        fld = strfldnm
                        ![fld(0)] = True
                        .Update
                    End If
                Next x

If anyone could help, it would be greatly apprecaited. If you need all the code, I'll gladly post it.

Thanks