I have a combo box where you can select a residence out of and 'available residence' query. i created a yes/no column to indicate when a house was assigned and placed it in the 'employee' table that the available query is based on. when i click the residence in the box it goes into a field called 'proposed_assignment' then i click assign and it becomes assigned. at this point i need to automatically change the yes'no box in the employees form to 'yes' and thus exclude it from my query. in my 'employee' table the address i just selected to a previous employee so my code is such:
UPDATE [Employees]
SET [House re-Assigned] = true
WHERE [Permanent_Address] = [All Employees]![Assigned_unit]
again, permanent_address is the address i am using to locate the previous owner of the house in my table and change their re-assignment status to 'yes'. this way they are removed from the query.
after this i requery my combo box. this is not working and my same choices appear. also when i run my sql i get a pop up box to enter parameters.
suggestions please??
UPDATE [Employees]
SET [House re-Assigned] = true
WHERE [Permanent_Address] = [All Employees]![Assigned_unit]
again, permanent_address is the address i am using to locate the previous owner of the house in my table and change their re-assignment status to 'yes'. this way they are removed from the query.
after this i requery my combo box. this is not working and my same choices appear. also when i run my sql i get a pop up box to enter parameters.
suggestions please??