Phil,
I read your message carefully.
ThisForm.grdOutPut.RecordSourceType should be 1-Alias!!!!!!!!>
>>>Insert ThisForm.grdOutput.recordsource = ''
before the SQL-select.
>>>
>>>HTH
>>>>cmdbutton.click is this:
>>>>
>>>>USE q:/qa/qdms2000/DOCUMENT/document share
>>>>SET MESSAGE TO ""
>>>>
>>>>l_cSearchtext='%'+upper(alltrim(ThisForm.txtSearchString.value))+'%'
>>>>
>><b>ThisForm.grdOutput.recordsource=''</b>
>>>>select * from document where title like l_cSearchtext order by number into cursor temp1
>>>>
>><b>brow</b>
>><b>ThisForm.grdOutput.recordsource=''</b>
>>>>ThisForm.grdOutput.recordsource='temp1'
>>>>ThisForm.grdOutput.refresh
>>>>thisform.refresh
>>>>
>>
>>
>>I tried the bolded additions, based on your suggestions (with only one null recordsource statement at a time) and neither worked....although the BROW shows that temp1 has records....
>>
>>I've got two strikes........lookin for an underhand lob here :)
>
> What is the RecordSourceType for this grid?
If it's not broken, fix it until it is.
My Blog