Hi Whil.

>>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? <<

Put this in the controlSource for the column:

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

I am assuming that prod_type is a field in the table you are using for the grid's RecordSource.

Marcia