Coding the option box ???

[andrep]

I have an option box with 4 choices !

The option box name is courrier!
the checkboxes within are 1, 2, 3 ,4 with names like
canpar, lumis, etc.

I have been trying to code it so that is the option4 is
not checked and cost is = 0 then
send a message box stating that the cost of the courrier
has not been entered!
I have tried various ways but cant seem to get the syntax right?



If Me![courrier].option4 = False And Me!Port = 0 Then
MsgBox "my message"
End If

 

[jebry]

Hi!

Try this code:

If Me!courrier <> 4 and Me!Port = 0 Then
etc.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[JohnLowell]

Just reference the Option Box:

If Me![courrier] <> 4 And Me!Port = 0 Then
MsgBox &quot;my message&quot;
End If

 

[andrep]

Works great many thanks!