I run 2 simple queries using a form button that updates 2 tables. Basically it imports data from an Excel spreadsheet in to a table called Header and a table called Pricer Details.
The header table contains Header ID, Company info, etc., and the Pricer Details contains data relating to actual product linked to the Header ID .
However, I don't want either query to run if the Header already exists in the first table, so I need to figure out how to tell access to go no further if the Header ID value is already entered.
The form button syntax is shown below.
Private Sub Update_Click()
DoCmd.OpenForm ("HeaderDetails"), acNormal