Many thanks to everyone who help me on this one, thats now not a propblem.
>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
Rob