RunTime Error 3075 in Query - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

RunTime Error 3075 in Query

Pete Santiago

5 years ago

I have went through troubleshoot steps and didn't work. I have a form with my customers and I can sort them by group with no problems; however, when I click the "Create Report" button. I get a Run-Time Error 3075: Syntax error in query expression 'SELECT * FROM EntityGroupQ WHERE GroupID = Forms!EntityGroupListF!GroupSearch ORDER BY LastName'. I have another Form for Birthdays sorting by month - it works fine both in Form and Report. Any guidance will help. Thanks in advance.

	Pete Santiago OP @Reply 5 years ago

	Pete Santiago OP @Reply 5 years ago

	Pete Santiago OP @Reply 5 years ago

	Richard Rost @Reply 5 years ago
You've got to take the ID outside of the quotes. `Me.RS = "SELECT * FROM CustomerT WHERE ID=" & Forms!CustomerF!CustomerID & " ORDER BY LastName"`

Pete Santiago OP @Reply

5 years ago

Thanks Richard for replying. I did what you suggested with triple checking spelling and quotations, but I'm now getting: "...WHERE GroupID = 139 ORDER BY LastName". I checked my query and changed my GroupID Column in Properties from a Combo Box back to Text Box. I even tried creating a new form. I'm pulling my groups from a helper table, so I'll start there and see if I changed something from text to number or vice versa somewhere. Love the challenge! Thank you for what you are doing!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View