How to edit Yes/No values from command button?

[jGURU]

Basically what i'm trying to do is, when the user clicks OK, the Yes/No attribute in tblHire is set to Yes. How can i acheive this? I have tried to use a macro but hasn't worked. Any help would be appreciated.

 

[Pat Hartman]

Why not just put the checkbox on the form. Then you won't need any code?

 

[jGURU]

Thanks, i considered that but the whole thing has to be automated, as there has to be a way of checking whether the item is availalbe or not (as far as i can see this is the only way). It is for a library assignment, so incase the user tries to hire the same item to another user (while on hire) some sort of error message should pop up. Thats what i am "theoretically" aiming for...long way from that

 

[Pat Hartman]

Your form should be based on a query and only items available for hire should show. Then when the user decides to "hire" something, he can check the "hire" checkbox. You may want to store the userID in the hired record so you can track who hired what.