Hi,
I think I am having trouble with the syntax in my update query.
Will someone please advise where I am making the error?
I am trying to reference a form field and i need to reference a number that is in column 2 of that field. (the field is a combobox)
The 'update to' field in my update query for a field called R1Total is the following:
[Forms]![frmRmResinNew]!R1.column(2)*[Forms]![frmRmResinNew]![PercentR1]
When i run the update query,
I am getting the error:
Undefined function '[Forms]![frmRmResinNew]!R1.column' in expression
Please help!
Thanks,
BJF
I think I am having trouble with the syntax in my update query.
Will someone please advise where I am making the error?
I am trying to reference a form field and i need to reference a number that is in column 2 of that field. (the field is a combobox)
The 'update to' field in my update query for a field called R1Total is the following:
[Forms]![frmRmResinNew]!R1.column(2)*[Forms]![frmRmResinNew]![PercentR1]
When i run the update query,
I am getting the error:
Undefined function '[Forms]![frmRmResinNew]!R1.column' in expression
Please help!
Thanks,
BJF