>I have a text box (thisform.text1) in which I enter a number. When I click a button it shows a table of results based on the syntax:
>
>SELECT modacad.key1, modacad.key2, modacad.key3, modacad.key4 ;
>FROM "C:\Data\modacad" ;
>WHERE thisform.text1.Value=modacad.key3 ;
>into CURSOR result
>
>But this shows a table with the results. How can I get those four fields in the select statement to show in a list box please?
with thisform.myListbox
.Rowsourcetype = 3
.Rowsource = ;
'SELECT modacad.key1, modacad.key2, modacad.key3, modacad.key4'+ ;
' FROM "C:\Data\modacad"'+;
' WHERE thisform.text1.Value=modacad.key3'+ ;
' into CURSOR result'
.Columncount = 4
endwith
Cetin