>>>>>how do you refresh a grid? I have one with the following
>>>>>WITH THISFORM.grid1
>>>>> ROWSOURCE= "Select price,quantity,noun from trans"
>>>>> ENDW
>>>>>and a click of a cmd button does the following :
>>>>>SELE TRANS
>>>>>GO TOP
>>>>>DELE next 1
>>>>>PACK
>>>>>the grid goes empty after clicking. I've tried refreshing the form too.
>>>>
>>>>You may want to select into a cursor, then set your recordsource to an alias of the cursor. Then when you want to refresh the grid set the recordsource to " " then run the select statement again and reset the recordsource to the refreshed cursor. Keep in mind you will lose some property settings doing this type of refresh.
>>>
>>>Instead of using "with thisform.grid1 ...recordsource=ytemp..endwith"
>>>I used "thisform.grid1.recordsource=ytemp"
>>>and it worked. How do you explain that, I thought they both accomplished the same thing.
>>
>>I'm not sure but in the old code you posted before you used ROWSOURCE not RECORDSOURCE. I assumed it was a typo.
>
>May I ask another quest related? After the grid gets "refreshed", I want control(focus) to go back to a textbox automatically, but it never does even when I implemtnt "thisform.mytextbox1.setfocus"

thisform.text1.Setfocus() should work. If it's a textbox in the grid make sure you set the record pointer as well so you are looking at the same record you started with, unless it was one you wanted to delete of coarse.