Phil,
>>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