select combo box first

[ooxx]

Hi, every

How can I have the form to know and to remind a message when on click
the command button to select the combo box first before doing anything in the
code?

Thanks,

 

[Ofer Cohen]

Use the OnClick event of the button to check if a value was selected in the
combo, if not prompt a message and exit the code.

Something like

If IsNull(Me.[ComboName]) Then
MsgBox "Must select a value in Combo"
Me.[ComboName].SetFocus ' set the focus to the combo
Exit Sub ' Exit the code
End If
' Put your code here

 

[ooxx]

Thank a lot.

Use the OnClick event of the button to check if a value was selected in the
combo, if not prompt a message and exit the code.

Something like

If IsNull(Me.[ComboName]) Then
MsgBox "Must select a value in Combo"
Me.[ComboName].SetFocus ' set the focus to the combo
Exit Sub ' Exit the code
End If
' Put your code here


--
Good Luck
BS"D

Hi, every

How can I have the form to know and to remind a message when on click
the command button to select the combo box first before doing anything in the
code?

Thanks,