Unless you're resetting your Column properties every time you'll have different column widths every time you requery. Check out this
http://fox.wikis.com/wc.dll?Wiki~GridSafeSelect~VFP. You create a readwrite cursor for your grid, run your query into a different cursor, then zap your grid cursor and append the results of your query. This way you don't lose your column settings. More info on why this occurs from
http://weblogs.foxite.com/andykramek/archive/2005/03/19/174.aspx Andy Kramek's blog.
Regards,
E.R. Gilmore
>Many thanks, ended up with:-
>
>
>thisform.paGEFRAME1.page3.grdProductTrans.RecordSource=""
>SELECT * from producttrans INTO CURSOR producttranstmp
>thisform.paGEFRAME1.page3.grdProductTrans.RecordSource=" select * from producttrans INTO CURSOR producttranstmp where bookinno=productfile.partno"
>
>
>Cheers
>Robin
Regards,
E.R. Gilmore