change a value on a certain table but my form is based on a query

[PrittyMe143]

my database is all about keeping records of computers assigned to an employee as well as the number of computer units in a certain department. so everytime a new employee is assigned with a unit, the number of computer units in the department where the employee belongs increases. now, on my form, i want to incorporate the search and the adding of new records. unfortunately, if i want to add a new record, i cannot update the number of computer units on the department table. by the way, i based my form on a query

 

[Fizzio]

You should not need to store explicitly the number of computers in each department as you can get this from totalling the number of computers each individual has from that department.

It does not matter if your form recordsource is based on a query unless you have calculated fields in your query which restrict the modification of the recordset.

 

[IfButOnly]

dàz-öl,
I assume that each employee belongs to only one department. If this is the case you shouldn't be keeping the number of computers on the department table, but getting that number by doing a query of the number of employees in a department with a computer.

 

[PrittyMe143]

whew!
i've been going into circles and i didn't notice! thanks for your time.

geee!