Subform Update Query

[darth sidious]

Hi Please see attached documents.

What I am trying to do is book students to a particular role for a play. In tblRoles I have two roles which can be booked role id 1 = Winged Monkeys and role id 2 = Dorothy.

On the form(activity 2) when I assign a role id to a student and save it I want it to deduct 1 from the norequired from the tblRoles for the RoleID chosen. However, it deducts one from norequired for both RoleIDs.

Any help would be greatly appreciated. I think the problem lies in my update query as I am deducting 1 from norequired but nothing to determine to deduct 1 from the norequired fro the RoleID put in on the subform.

Many thanks

Darth

 

[bob fitz]

Can you post a copy of the db in A2003 mdb format.

 

[Old Man Devin]

Sounds like your update query needs a criteria for the deduction. So in the RoleID field add critiera that it is equal to the RoleID of the thing currently being looked at in the form e.g. "=Forms!Roles!RoleID"

 

[darth sidious]

Can you post a copy of the db in A2003 mdb format.

Hi

Now attached as 2003 mdb

Darth