Access Error 424 Object required in Access

X

xAgyex

Joined
Mar 21, 2011
Messages
1
Reaction score
0
Here is my code.

I have a table "InventoryData" with all our UPC barcodes, and want to makes sure then the user enters one of the codes on the list from the form "UPC Scan Entry Form".

But I get error 424 when the bar code is entered

Private Sub UPC_BeforeUpdate(Cancel As Integer)

If Nz(DLookup("UPC", "InventoryData", "UPC =" & UPC_Scan_Entry_Form!UPC)) Then
MsgBox ("This Defect is already listed")
End If

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
424 object required for object ReportItem 0
FormCode - Converting Type-E UPC to Type-A (barcodes) 2
Excel Prevent Save if Checkboxes values are false in excel workbook 0
VBA Code for converting Type-E UPC to Type-A (barcodes) 1
Create a yes no message on a command button on click 0
SetFocus not working properly 4
Run-Time Error '424': Object required when Saving Document 6

Top