Hi,
Try this:
WITH thisform.list1
.RowSourceType = 0
.RowSource = "fistask.project_no,workpkg_no,task_num,task_desc"
.RowSourceType = 6
.refresh()
.setfocus()
ENDWITH
HTH,
Arriyel
>I have a list box and i want to show the data in the list box directly from table not from view:
>right now it is getting data from view.
>
>how can i modify it to get the data directly from the table instead of view.
>
>
>when ever i call the form this is what happening and the listbox is in the form and it is getting populated using the data in the view:
>
>
>
>In the got focus event of the form this is written:
>
>=tableupdate(.t.,.t.,"workpkgTask_view")
>=requery("WorkpkgTask_View")
>thisform.list1.refresh
>thisform.list1.setfocus
>
>
>In the list box rowsource property this is written:
>workpkgtask_view.project_no,workpkg_no,task_num,task_desc
>
>**************end *******
>
>the table name is fistask and it has the same fields
>
>so what can i do please give me an advice how i can show the data directly from table
>
>Thank you very much.
Speak using soft and sweet words in case you have to eat them later.