Hi Quinn ---

>The current statment we are using is as follows
>
>select * from(hf) where rn=tbrdesktop.spinner1.value noconsole into table hftemp
>
>hf being the database selected by a combo
>
>We are then using the hftemp database as the record source in the grid. The problem with all that is when we issue thisform.grid1.recordsource="hftemp", to refresh the grid, all of our width settings for the grid are ignored.
>

Works for me :)

I assume "hf" is a public variable that ends up containing a table name?

OK.....try this instead: In your database, do....

CREATE VIEW gridvue AS SELECT * FROM (hf) WHERE rn=?tbrdesktop.spinner1.value

Set the recordsource to "gridvue"

Whenever any method could cause a change to the values, do a =REQUERY("gridvue")

Clearer now?

John