Hello im trying to run a query to move customers from one table to another based off whats entered in the form fields but if say one form field is empty i get a error so in the following
if there was nothing entered for BPhone on the form because the people do not have a Business phone then I get a error and it wont add it to the contacts table :/
Code:
strSQLApp = "INSERT INTO contacts ([Last Name], [First Name], [Phone], [Business Phone]) VALUES ('" & LName & "', '" & FName & "','" & PhoneNum & "','" & BPhone & "')"if there was nothing entered for BPhone on the form because the people do not have a Business phone then I get a error and it wont add it to the contacts table :/