I am using a list box where i want to display the records using the following query.
Only the matching records need to appear in the list box.

Can you please advice me how to show the records in the list box.


SELECT * FROM sub WHERE sub.project_no = this.project_no.value
AND sub.workpkg_no = this.workpkg_no.value
AND DELETED() = .f. ORDER BY project_no, workpkg_no



For list box i writing this code.

WITH thisform.list1

.RowSourceType = 0
.RowSource = "sub.project_no,workpkg_no,sub_sec,sub_para,sub_seq,sub_title"
.RowSourceType = 6
.refresh()
.setfocus()
ENDWITH



Thank you Very much.