Macro to copy value of field in form, into a table

[agehoops]

I've just created a macro so that when the form is run, and the values are loaded into the various fields, those values are then moved into a table. I've used the SetValue action to do this, but every time it is run, the error message comes up, saying:

"The object doesn't contain the Automation object 'tblPercentages'"

How do i solve this problem?

Thanks

 

[ducker]

if you're updating a table with values from a form, wouldn't you want to run an update SQL statement to update that record in the table with the values in your form?? I'm not sure if you can do this with a macro.