Writing a value to a table using a macro

[Leathem]

I'd like to be able to assign a value to a cell in a table by putting a command button on a report and having it place the value in the table when the button is clicked. I can get the macro associated with the button to do various things but not what I want. I've tried Set, but I get an error message that the database can't find the field referred to in my expression. What I have now is Set [tablename]![fieldname]="c". What am I doing wrong here?

 

[Phivosz]

You cant write directly to a table like that... You either need to write some code or the easier (but not so neat) way is to use a form bound to the table and assign the value to the control on the form which corresponds to the field you want to update.