Quick VB Prog. ?

[Adam]

I have a radio button on my form. When the radio button =
True a combo box becomes available to create queries
from. The problem arises when the radio button is
selected, but no data is selected or typed in the combo
box. I need to put in a safety to make sure that there is
some data present in the combo box if the radio button is
selected.

Something along the lines of:

If forms![main form]!Combo.value = Null Then
MsgBox "Error"
End IF

This does not work...Any suggestions?

Thanks,
Adam

 

[Ed Terlouw]

Adam try,

if isnull(forms![main form]!Combo.value) then msgbox "error"

Ed