Change the RowSource of the listbox to use the table instead of the view:
fistask.project_no,workpkg_no,task_num,task_desc
>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.
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi