i am preparing a data base program where i manage the data of our company projects ....
we have several types of expenses and these expenses belong to certain work Item , every project has his own work Items
so i have many projects , and each project has several work items ...
now when i input data ... i have a form where i chose one of my projects from a combo box ...
then under it, there is a tab control , in each tab i have several data to input , one of these data is the "work Item"
i chose the work Item from a combo box , the data of the combo box comes from a child table linked to the "projects" parent table
now lets say i have "project 1" , "project 2" and "project 3"
"project 1" has the following "work Items" : concrete , plaster , paint
"project 2" has the following "work Items" : concrete , block work , electrical , elevators
"project 3" has the following "work Items" : paint , marble , plumbing
the problem is that when i chose a project form the combo box , the data in the combo box of the "work Item" does not refresh by itself ... i need to press F5 to refresh the data in the work Item combo box in order to show the work Items that belong to the chosen project ...
i tried requery command but it did not work
how can i make the data in the Work Item combo box located inside the tab control to refresh once the the data in the "project" combo box is updated ?
please note that the combo box of "work Item " is not located directly in a sub-form inside the main form ,
it is located in a sub-form placed inside a tab control inside the main form
please i need help fast on this one
thanks a lot