Message box

[pmadan]

Hi I have 2 fields on the form. One is a combo field with drop down values

Yes
No
No Answer

and one is a text field.

I would appreciate if you could help me with a code wherin if the value selected on the Combo box is "No" and there is data existing in the text
field then there shoud be a message pop up.

 

[Access_guy49]

Do an evaluation on the "On change" event of the drop down control.

if me.dropdownboxname = "No Answer" AND me.TextboxName  <> "" then
 msgbox "Something"
end if

You may need to change textboxname <> "" to Not textboxname IS Null