>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
create a view of the data with a logical expression like you said.
probably that works
You can also use dynamiccurrentcontrol and use that expression to set a checked or a uncheked box as the current control