Override a text box with a certain value 'On Click'

[benny1983]

Hi all,

I have an audit form which calculates a rating based on certain selections on the form.

The final rating is diaplayed in an unbound text box using the following code in the control source:

=IIf([txtScore]<51,"Below Requirement",IIf([txtScore]<100,"Feedback Required","Achieved Requirements"))

It works perfectly however, I want the user to have an option to updrade the rating (which is a discretional rating so there are no set paramaters)to 'Exceeds Requirement' upon click of a button.

Every time I try to asign a value 'on click' I get an error stating that I cannot assign a value to that object. Is there any way around this?

Seriously stuck and need to have this up and running ASAP.

[jforbes]

There are a couple of different ways you can go about this. Probably one of the easiest, without redoing much, would be to add a Checkbox under or around your Unbound field and include it's value in the Source for your Unbound field.

If you were to add a Checkbox named chkOverrideCheckbox, the following ControlSource should work:

=IIf([chkOverideCheckbox]<>0,"Achieved Requirements",IIf([CustomerID]<1,"Below Requirement",IIf([CustomerID]<2,"Feedback Required","Achieved Requirements")))
 

[benny1983]

@jforbes
Works perfectly! Thanks.