This may be in another forum but, i could not find anything that seemed to be what i needed. Here goes, I have a "Projects DB" with the following tables. table1 = projID#
Desc.
Status
Proj.Coord
dates(start,completed,etc.)
Table2 = ProjID#
Task
Updates
Employee.
What I would like to do is this: Have a combo box labeled "Project coord." when this is selected, a list of project coord. will apear.
Next,I would like to be able to select a Coord. from combo box1 and have only their projects appear in another combo box(2)
Then...I would like to be able to have them select from the combobox(2) the project they need to update and/or modify. the way it works now is, I have buttons on the main PROJECTS form that the user has to "Tab" through records until they get to the one they need to modify. It was not bad in the beginning but now there are over 100 projects in the database that the staff have to weed through. I am not sure if this is clear as to what i need help with but, if not please let me know and maybe i can zip up the database(Minus about 80 projects)
Desc.
Status
Proj.Coord
dates(start,completed,etc.)
Table2 = ProjID#
Task
Updates
Employee.
What I would like to do is this: Have a combo box labeled "Project coord." when this is selected, a list of project coord. will apear.
Next,I would like to be able to select a Coord. from combo box1 and have only their projects appear in another combo box(2)
Then...I would like to be able to have them select from the combobox(2) the project they need to update and/or modify. the way it works now is, I have buttons on the main PROJECTS form that the user has to "Tab" through records until they get to the one they need to modify. It was not bad in the beginning but now there are over 100 projects in the database that the staff have to weed through. I am not sure if this is clear as to what i need help with but, if not please let me know and maybe i can zip up the database(Minus about 80 projects)
