General information
Title:
Populate data thru query in list box
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only