>Afternoon all,
>
>I am trying to simulate behaviour in a grid from a browse
>
>the browse command was as follows
>

>disp_type = IIF(prod_type=1, "Intl", IIF(prod_type=2,"Ded",""))
>

>
>nothing special.. but how do I do the same thing in a grid's textbox?
>If I try and modify the Value / ControlSource it won't let me.
>
>I can't imagine this is too difficult - just can't figure it out.
>
>TIA

Will,

I'm using a grid class for a similar purpose. What I've done is have a base form that it's on and assign the RecordSource in the form's Init. The grid's RecordSource has an assign method that then fires and does things like replace logical fields with check boxes and so on.