HandsOn Using the NotInList Event Procedure for the Combo Box Control

1. Open the frmDataEntryMain form in Form view.

2. Select the Site ID from the combo box.

3. Select the Room No from the combo box or type your own room number value in this box.

4. Type any value in the Room Type combo box and click on the Operating System combo box. This will trigger the cboRoomType_NotInList event procedure code to run. Your custom error message should appear. Click OK to the message box. Notice that Access does not display its own default message because you set the Response argument to acDataErrContinue.

5. Select the Room Type value from the combo box.

0 0

Post a comment