Form Event to disable a checkbox

[mls via AccessMonster.com]

I want to disable FINAL (check box field) if certain products are selected in
my PRODUCT text box.

Ex:

Me.Product in(‘one ‘,’two’,’three’ ) then
Me.final.enabled =false
Else Me.Final.enabled = true

So my question is: what form event is best to include this condition?

 

[DrGUI]

Put your code in the Product_AfterUpdate event.

 

[fredg]

I want to disable FINAL (check box field) if certain products are selected in
my PRODUCT text box.

Ex:

Me.Product in(¡one ¡,¢two¢,¢three¢ ) then
Me.final.enabled =false
Else Me.Final.enabled = true

So my question is: what form event is best to include this condition?

Use the [Product] AfterUpdate event.
If Me.[Product] = "One" Or Me.[Product] = "Two" or Me.[Product] =
"Three" Then
Me.[Final].Enabled = False
Else
Me.[Final].Enabled = True
End If

If you had more choices it might be better to use a Select Case
statement.

 

[Barry A&P]

Possibly also put it in the forms Current event so it will work when using
the navigation buttons??

Barry

 

[mls via AccessMonster.com]

Actually I have 10 - 12 choice. How can I use select case?
Also I am having problems with continuing to next line.. I am using " & _
and it gives me compile error.

 

[mls via AccessMonster.com]

works perfectly if this is placed in Form_Current() &
result_reported_AfterUpdate() events..
If Me.[product] = "one" _
Or Me.[product] = "two" _
Or Me.[product] = "three" _

Thank you

 

[Barry A&P]

Search CASE in Forms Coding there are lots of examples

next line is a "Space" and a Underscore
check out tony Towes example in this link
http://www.granite.ab.ca/access/email/formattedsamplecode.htm

Barry