ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,251
- Office Version
- 2007
- Platform
- Windows
Hi,
I am currently using the code below & also supplied a screenshot of the form.
The issue i have is that when i press CHECK MY PART NUMBER it should not continue to run the codeif ComboBox2 is empty.
Basically ComboBox2 should show a value for it to continue,if empty then i will add a Msgbox but not sure where ive gone wrong.
Please advise thanks
I am currently using the code below & also supplied a screenshot of the form.
The issue i have is that when i press CHECK MY PART NUMBER it should not continue to run the codeif ComboBox2 is empty.
Basically ComboBox2 should show a value for it to continue,if empty then i will add a Msgbox but not sure where ive gone wrong.
Please advise thanks
Rich (BB code):
Private Sub CheckMyPartNumber_Click()
If ComboBox2.Value > 1 Then
HondaParts.MyPartNumber.Value = ComboBox2.Value
HondaParts.Show
Else
MsgBox "NO HONDA PART NUMBER WAS SELECTED", vbCritical, "HONDA PART NUMBER LOOK UP MESSAGE"
End If
End Sub