Regards to all
I have designed a user form that’s applicable to two payment ledger records:
- SERVICE FEE PAYMENT (Sheet1)
- FUEL SERVICE PAYMENT(Sheet2)
In both Sheet 1 and Sheet 2 there is a corresponding arrangement of the NAMES of Payees who are listed in Column A, the ID NO of each Payee listed in Column B and Dates in this case from January 1st to January 16th 2021 listed in Row 1 of both Worksheets from Columns C to R.
The mode of operation is that when the User Form is loaded, the operator has to key in the ID NO of the Payee for example KUC 654. The Name box will instantly display the Payee’s name BEN HARRISON. Proceed to select the type of Payment in the combo box list either SERVICE FEE PAYMENT or FUEL SERVICE PAYMENT. Enter the amount of payment received and click at the Date box to load the Calendar. From the Calendar displayed choose the Month and date of payment. Press Enter and the Payment amount will be entered into the intersecting cell corresponding to the User’s name and the selected date.
The form is working fine except for a noticeable concern. If one was to enter a none existent ID NO, for example KLO 776S the name box surprisingly displays ROBERT HALSBERG. Assuming one is not keen enough to note the discrepancy there is a likelihood that a date payment can be made for a person whose ID NO does not correspond to the ID NO specified.
Can anyone one kindly provide me enlightened guidance on how I adjust my existing code to prevent any payment being made to a none existing ID NO?