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