Hi Moe,
Thanks for the additional rep points.
See the attached file which implements the following each in a different control:
a. Change Event
b. Exit Event
c. Before Update Event
d. ComboBox with No Events. Data entry from OptionButtons, ComboBox List and SpinButtons.
e. Text Box with No Events. Data entry from Optionbuttons and SpinButtons. This control is locked to prevent incorrect data entry.
Pros and Cons of Each Method:
a. Change Event only handles user numerical input one digit at a time.
b. Exit Event - FAILS to handle selections from the Combo Box until focus is moved to a different control.
This is OK if the ComboBox list has correct values (which it should have).
c. Before Update Event - has identical code and behaves the same as the Exit Event.
d. ComboBox with no Event allows data entry from List or from data entry. Verification done when 'Process Data' is selected.
e. TextBox with no Event is locked so data entry is either from 'OptionButtons' or from SpinButtons.
I added 'Batch processing' with a 'Process Data' Command Button. It verifies data in each control. A status message is displayed in a 'Status Label' at the end of verification. If there are data input errors, the errors must be corrected before data processing is allowed.
Lewis
Bookmarks