This should be easier, but I'm in a panic and under pressure (lol). I have a form with a subform. The user will enter a number on the subform and I want to compare the User's entry with a number on the main form. If it matters, the number on the main form is displayed using the DLookUp function to get the component number from a Master Table. However, there is also a 2nd subform on the main form that displays data directly from the Master Form that I am seeking. Here are the names:
Main Form: FDL4 Control with DLookup value is named: MICAN2
SubForm 1: FDstL4 Control where data is entered is named: Can Number
SubForm 2: FDMIL4 Control that contains the Master Table value is named: MI CAN
the data is being entered using a handheld barcode scanner so I want the screen to throw up an error and halt the entry if the entered data does not match the value in the Master Table.
Any takers? Thanks.
Main Form: FDL4 Control with DLookup value is named: MICAN2
SubForm 1: FDstL4 Control where data is entered is named: Can Number
SubForm 2: FDMIL4 Control that contains the Master Table value is named: MI CAN
the data is being entered using a handheld barcode scanner so I want the screen to throw up an error and halt the entry if the entered data does not match the value in the Master Table.
Any takers? Thanks.