A
Alberto Vargas
Hi there,
I am developing an ACCESS database for projects coordinated by managers. I
use form and subform to check the projects by manager.
When I use the form some of the projects are cut and pasted into another
manager and it loolks like ACCESS is overwriting one of the project from one
manager to another jsut when I choose the manager with the compbo box of my
fom. Let me explain:
We have 5 projects and 2 managers.
Manager 1 has project 1,2 and 3 and manager 2 has projects 4 and 5.
I create a form using a combo box to show the manager and a subform to show
the projects. The link field is the manager name.
When I open the form the manager 1 always shows up at the firt time and in
the subform there are projects 1, 2 and 3. Then I use the combo box to choose
the other manager and it shows the projects 4 and 5.
But when I close the form and I open it again, the combo box show3s manager
1 but the subform only shows project 1 and 2 and when I choose manager 2,
project 3 shows aloing with project 4 and 5 on the subform. And this is not
correct.
If I continue closing and open the form, one project is cut and asted from
manager 1 to 2.
It is like the form i overwriting one of the projects to manager 2 just by
clicking the combo box. I do not have any idea why this is happenning.
I am not advanced user of ACCESS, but any help on this is very appreciated.
Thanks
Alberto Vargas
I am developing an ACCESS database for projects coordinated by managers. I
use form and subform to check the projects by manager.
When I use the form some of the projects are cut and pasted into another
manager and it loolks like ACCESS is overwriting one of the project from one
manager to another jsut when I choose the manager with the compbo box of my
fom. Let me explain:
We have 5 projects and 2 managers.
Manager 1 has project 1,2 and 3 and manager 2 has projects 4 and 5.
I create a form using a combo box to show the manager and a subform to show
the projects. The link field is the manager name.
When I open the form the manager 1 always shows up at the firt time and in
the subform there are projects 1, 2 and 3. Then I use the combo box to choose
the other manager and it shows the projects 4 and 5.
But when I close the form and I open it again, the combo box show3s manager
1 but the subform only shows project 1 and 2 and when I choose manager 2,
project 3 shows aloing with project 4 and 5 on the subform. And this is not
correct.
If I continue closing and open the form, one project is cut and asted from
manager 1 to 2.
It is like the form i overwriting one of the projects to manager 2 just by
clicking the combo box. I do not have any idea why this is happenning.
I am not advanced user of ACCESS, but any help on this is very appreciated.
Thanks
Alberto Vargas