Update table record

[10TR]

I have a table named tblroom with a field named theater. I want to update the table field from a calculated field called theater in the form called frm-room.

The record in the form creats a sum from a calculation. I need to have it populate the record theater in the table.

I have done this before but I can't remember how I did it.

Any help is appreciated.

 

[10TR]

I figured it out.

Don't perform the calculation directly in the field but use After Update in the field being calculated and have it post.