Recent content by skizzy

Perfect! Thanks!

Perfect! Thank you!

I don't need the first to run prior to the second. I just want them to run together. Let me show the whole code. Private Sub Submit_Click() Dim QueryToSubmitData As String Dim QueryToSubmitBlank As String If Me!WhatToDo = "Add Employee" Then If IsNull(Me.DeptCombo) Or...

Hi, I have two queries setup to insert data into two separate tables that I want to combine into one. I am not sure how to write it. Any help would be appreciated. QueryToSubmitData = "INSERT INTO Employee_List (ID, LName, FName, DeptId, Limit, Active) SELECT '" & Me!EmployeeID & "', '" &...