I am having a problem with this code:
Private Sub Command1_Click()
Let Data1.recordsource = "SELECT * FROM [STUDENT QUERY] WHERE MAJOR=me!TEXT1.text"
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.