I am creating a UserForm for users to complete to create a new account. I have the following boxes in my form:
AccTypeCodeComboBox
AccTypeDescrTextBox
AccNumberTextBox
AccDescrTextBox
The code below runs on exiting the AccNumberTextBox.
The line "ChkType = AccTypeDescrComboBox.Value" results in a Compile Error: Variable not found - "AccTypeDescrComboBox" is highlighted.
The line "ChkNr = AccNumberTextBox.Value" results in a Run-time error 13: Type mismatch - "AccNumberTextBox" is highlighted.
The runtime error only occurred after I added the section starting at "If IsNull(Me.AccNumberTextBox.Value) Then". Before that there were no runtime error.
I need help with:
1) As what must I define the variable "AccTypeDescrComboBox"?
2) How do I check that "AccNumberTextBox is not empty?
I would appreciate any suggestions you may have.
Bookmarks