update one field based on 5 other yes/no fields

[jimc01]

On my application I am trying to automatatically set a yes/no field based on another five yes/no fields .. currently I run an update query from a control button, but there must be an easier way .. but I am blinkered out ... any advice?

thanks JimC

 

[PHV]

any advice on WHAT ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jimc01]

Sorry if there was insufficient info on my question - I have a form which users access to approve jobs, there are six conditional check boxes that users check as the vaious job parameters are met - all I want to happen is the job approved check box to be set true when all other six check boxes (yes/no fields) are set - at the moment,I have attached an update query to each check box which when clicked, the query looks at the other five check boxes and if they are "true" the approved check box is then set to "true". this works to a point, but the form does not refresh until I either update another record, or close and open the form.

JimC

 

[PHV]

Something like this ?
In the BeforeUpdate event procedure of the form:
Me![job approved] = (Me![ckeck 1] And Me![ckeck 2] And Me![ckeck 3] And Me![ckeck 4] And Me![ckeck 5] And Me![ckeck 6])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jimc01]

Thanks PH - mist cleared ... I adapted your suggestion and got over my problem - sometimes the obvious just don't seem so obvious.

JimC