I am trying to reuse a procedure for different tablenames
my procedure is like this.
_______________
dim rst as dao.recordset
set rst = db.openrecordset("table1")
rst ("AFieldnameinTable1") = 1
_______________
IF:
rst ("AFieldnameinTable1") = 1
I want to replace ("AFieldnameinTable1") with a variable name
SO:
Set Fieldname = "AFieldnameinTable1"
rst (Fieldname) = 1
Last Line -- rst (Fieldname) = 1 ---DOES NOT WORK
it says:
ITEM not found in this collection:
IT DOESNT SEE IT AS :
rst ("AFieldnameinTable1")
BUT AS :
rst (Fieldname)
I TRIED PUTTING IT AS :
"rst (" & Fieldname & ")"
SAYS SYNTAX ERROR
Any techniques you can share, please?
my procedure is like this.
_______________
dim rst as dao.recordset
set rst = db.openrecordset("table1")
rst ("AFieldnameinTable1") = 1
_______________
IF:
rst ("AFieldnameinTable1") = 1
I want to replace ("AFieldnameinTable1") with a variable name
SO:
Set Fieldname = "AFieldnameinTable1"
rst (Fieldname) = 1
Last Line -- rst (Fieldname) = 1 ---DOES NOT WORK
it says:
ITEM not found in this collection:
IT DOESNT SEE IT AS :
rst ("AFieldnameinTable1")
BUT AS :
rst (Fieldname)
I TRIED PUTTING IT AS :
"rst (" & Fieldname & ")"
SAYS SYNTAX ERROR
Any techniques you can share, please?
Last edited: