how can i change the value in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to change a value in a field in a table based on the value from a generated report, I us the setvale in a report and point it to the field in a table and tell it to use the field from the report (keeping both the table and report open) but the macro tells me it cant find the expression
![field]! and i use the expression builder to make sure i am using the proper spelling..is it possible to run a report and get the final figure and input it to a field in a table using a macro??
 
At100,

No, this is not possible. You can't refer to the value of a report
control in this way, and you can't use a field in a table as the Item
argument of a SetValue macro, for one thing because Access has no way of
knowing which record in the table you mean, and for another thing Access
syntax doesn't provide the means for you to refer to a table field.

Without knowing more details of what you are doing, it is difficult to
give specific advice. But it sounds like you could probably use a query
to obtain the calculated value that you want to put into the table, and
then use an Update Query to insert this into the required field in the
table.
 
Back
Top