Search results

You guys are awesome!! Thanks. Those examples should point me in the right direction.

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. Am I using 'runsql' incorrectly?

I think that fixed that error. Thanks I am now getting: runtime error 2342 A runSql action requires an arguement consisting of a Sql statement. Thanks

strsql = "Select * from Master where Technician_Name = "' & str & "'; " I am receiving the same error code as before. How frustrating! Thanks for the input thought! :cool:

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...