dale_j1992
Registered User.
- Local time
- Today, 03:01
- Joined
- Sep 23, 2016
- Messages
- 26
Morning All
i am having some trouble with the following code.
Basically when the user types in a barcode it should lookup to ensure the barcode is logged for this cycle.
i have tried changing it to notisnull and it still has no effect.
Any help would be greatly appreciated.
Kind regards
i am having some trouble with the following code.
Code:
Private Sub CRANK_1_Change()
Dim Answer As Variant
Answer = DLookup("[Barcode]", "tbllogfurnaces", "[Barcode] = '" & Me.CRANK_1 & "'" And "[FURNACELOADNUM]", "tbllogfurnaces", "[furnaceloadnum] = '" & Me.FURNACENUM & "'")
If IsNull(Answer) Then
MsgBox "This crankshaft was not in this furnace load" & vbCrLf & "Please enter again.", vbCritical + vbOKOnly + vbDefaultButton1, "Incorrect Part"
Cancel = True
Me.CRANK_1.Undo
End Sub
Basically when the user types in a barcode it should lookup to ensure the barcode is logged for this cycle.
i have tried changing it to notisnull and it still has no effect.
Any help would be greatly appreciated.
Kind regards