Search results

I am having alot of trouble setting up my comboboxes as criteria for a query. The problem lies in that I want the user to be able to choose any combination of the 5 comboboxes. Meaning that user could choose 2 or 3 or all 5 and leave some blank. I want the selections in the comboboxes to be...

I am trying to take the results of an inputbox and place it into a SQL statement. Here is the Code: Function Technician() Dim str As String Dim strsql As String str = InputBox("Type in Technician's Name") strsql = "Select * from Master where Technician_Name = " & str & "; " DoCmd.runsql...