DB Grid data control

I am having a problem with this code:

Private Sub Command1_Click()


Let Data1.recordsource = "SELECT * FROM [STUDENT QUERY] WHERE MAJOR=me!TEXT1.text"

Data1.Refresh


End Sub

The Data1.refresh gives me an error that says " to few perimiters, expected 1"  if I put me!text1 in 'me!text1' it is not going to the text box.  How do I make it recognize the text box.  If I say "WHERE MAJOR='CIS'" IT WORKS FINE, BUT I DO NOT WANT TO HARD CODE THIS.

Any suggestions?

Thanks
DAVIDHAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
HenryChanEConnect With a Mentor Commented:
Try to convert to this,

Let Data1.recordsource = "SELECT * FROM [STUDENT QUERY] WHERE MAJOR= '" & trim(me!TEXT1.text) & "'"

    Data1.Refresh

This method always work. If not, check that you string really contains something !
0
 
DAVIDHAuthor Commented:
Edited text of question
0
 
DAVIDHAuthor Commented:
THANK YOU!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.