Neil,
Try building the Where statement into a string then using that
lcWhere = "modacad.key3$thisform.text1.Value"
lcWhere = "modacad.key3==thisform.text1.Value"
SELECT * ;
FROM ("U:\Data\modacad.dbf") ;
WHERE &lcWhere;
order BY mainkey ;
INTO CURSOR crssearch
HTH
Caroline
>Morning,
>
>I have form with an edit box whereby somebody will enter a number. When the user clicks the button on the form a list of results are shown in a list box. What I would like to do is allow the user to change the search criteria with a combo field. Therefore I know have a combo field with the values =, == and $.
>
>What I would like to do is incorporate the conditions above so that the search is carried out accordingly: At the moment I have the where statement set to modacad.key3$thisform.text1.value.
>
>I need to substitute the $ and replace it with the value from the combo in this statement.
>
>SET EXCLUSIVE OFF
>SET DELETED ON
>
>SELECT * ;
>FROM ("U:\Data\modacad.dbf") ;
>WHERE modacad.key3$thisform.text1.Value ;
>order BY mainkey ;
>INTO CURSOR crssearch
>
>with thisform.list1
> .RowSourcetype = 3
> .Rowsource = 'Select crssearch.mainkey'+;
> ' from crssearch'+;
> ' into cursor crsreslist'
> .ColumnCount = 1
>ENDWITH
>
>Any help would be appreciated
>
>Many Thanks
Caroline