>I tried that and it works, but after I switch to another page frame to and back to this one then i refresh it with thisform.grid1.recordsource = thisform.grid1.recordsource it shows the the D or R data that is in my field? instead of the approved disapproved that my iif statement in the controlsource.
>
>Thanks Kelly

And this is the correct behaviour, because what you did - you reset the grid recordsource and therefore the column.controlsource to just the field name (actually it could be even some other field in the default field order). You have to reset the column.controlsource = IIF(...) again. Better not to use resetting the grid.recordsource in order to refresh the grid - use grid.refresh() as it supposed to be.