Stop error message

[MikeyH]

Have a form to select a file and import data record from EXCEL and put in Access tbl. Have code installed to prevent importing a record already brought into Access. How do I block error msg telling me "Cannot add record..... etc." Don't know the code # for the error msg.

 

[donbettis]

I am assuming you are using a query to do the import…To stop the error messages try this…

DoCmd.SetWarnings False ‘This turns the error messages off

DoCmd.OpenQuery "qryYourQryName", acViewNormal, acEdit 'This is your qry

DoCmd.SetWarnings True ‘This turns the error messages back on