I have a form that contains a field titled BarCode. This field is bound to a table call it Table-AAA. When the user enters a number into the barcode field I want the application to validate that the number the user entered into the Barcode Field is a number listed in TABLE-BBB. If it is not a valid value I will pop up an error message. The name of the field in Table-BBB to use in the validation process is "AssetNbr".
I know that this VBA code will be placed on the After-Update event of the BarCode field but I do not know how to create this code.
Any Code suggestions on how to do this?
Thanks in advance for your suggestions.