DB Grid data control

Posted on 1998-07-19
Last Modified: 2010-05-03
I am having a problem with this code:

Private Sub Command1_Click()

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


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?

Question by:DAVIDH
  • 2

Author Comment

ID: 1466210
Edited text of question

Accepted Solution

HenryChanE earned 50 total points
ID: 1466211
Try to convert to this,

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


This method always work. If not, check that you string really contains something !

Author Comment

ID: 1466212

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA saving file message display 5 67
Using "ScreenUpdating" 6 65
Excel - Save a copy of work book 13 85
Exit a vb6 apps when a calling it apps closes 15 48
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question