I shamefully look for an answer to my newbie question
I have created a form that should allow user to communicate with the database. The search criteria are filled withing Textbox. Then the string from the textbox is transferred into the SQL Command string. However, it is not included...
SQLStr = "SELECT * FROM tblMain WHERE ID = " & txtSearchBox.Text & "'" MsgBox(SQLStr)
And only this part is stored in SQLStr variable = "SELECT * FROM tblMain WHERE ID = " - (pops up in msg box)
Any hints? ;/