I have a grid whose recordsource is a table. Presently each column in the grid has a field in the table as a controlsource. I want to put a checkbox control in the grid. The checkbox will indicate the presence or absence of some other fields in the grid. Say if !empty(table1.field1) and !empty(table1.field2) I want the checkbox checked. The checkbox does not have a corresponding field in the recordsource table. The only update available on the grid is row delete. How is a good way to setup the checkbox?

Thanks

Brenda