Hi,
Hope you can help.
I have two arrays and want to use to edit a table. For example this is what it looks like normally:
rs1.Edit
rs1![Ready Date] = "[R Date]"
rs1.Update
rs1.MoveNext
This is what I am after:
rs1.Edit
myarray1(1) = myarray2(1)
rs1.Update
rs1.MoveNext
myarray1(1) = "rs1![Ready Date]"
myarray2(1) = "[R Date]"
Is this possible?
Thanks for any help
Peter
Hope you can help.
I have two arrays and want to use to edit a table. For example this is what it looks like normally:
rs1.Edit
rs1![Ready Date] = "[R Date]"
rs1.Update
rs1.MoveNext
This is what I am after:
rs1.Edit
myarray1(1) = myarray2(1)
rs1.Update
rs1.MoveNext
myarray1(1) = "rs1![Ready Date]"
myarray2(1) = "[R Date]"
Is this possible?
Thanks for any help
Peter