Consult everybody, why always shows a lack of: this statement statement end?
Adodc1. RecordSource="Select * From user information table where user name='Text1. The Text" "'"

CodePudding user response:

 
Adodc1. RecordSource="Select * From user information table where user name='" & amp; Text1. Text & amp; "' 
"

CodePudding user response:

String concatenation:
S="A" & amp; "B"
Msgbox s