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
Neil Lewis
IT R&D Manager
Velmore Ltd