how to use immediate window, debug.print

[bseymour12]

Please help, I am desperate on this issue. I am quite the novice at this but I hope someone out there can offer assistance. I am currently using access 2010. I am trying to use syntax recommended for the immediate window as suggested by articles. Here is the string:

strSql = "SELECT tblPersons.PersonID, tblPersons.lastName, tblPayments.paymentAmt, tblPayments.paymentDate, tblPayments.UnitID " & _
"FROM tblPersons LEFT JOIN tblPayments ON tblPersons.PersonID = tblPayments.personID " & _
"WHERE tblPersons.PersonID " = Me!txtpersonID & _
" ORDER BY tblPersons.PersonID, tblPayments.paymentDate DESC;"

I am typing ?strSql in the immediate window but NOTHING is happening. I have typed command (in code) debug.print strSql and ?strSql in immediate window but nothing happens. I seem to get a response from some function such as now(), but cannot see the sequel string as suggested by all of the reading. Do I need to set some parameters in some properties window? I have the form open in design view. This is in a form module on the page with a lot of other code, if this makes a difference (none of the other code uses strSql as a string value.) I apologize for the very rudimentary nature of this question, but I do not get it!

[Seth Schrock]

The code has to be running when you enter the ?strSql in the immediate window. If you click in the gray area to the left of your code window (between the list of modules, forms, and class modules and your code), a red dot will appear. This is a break point for your code. Place one on the line just below the code that you provided above. Then run your code. If this is in a button's OnClick event, then click the button, etc. The code execution will stop on the line you selected. Now you can enter your stuff in the immediate window.

[BikeToWork]

Shouldn't "WHERE tblPersons.PersonID " = Me!txtpersonID & _
be "Where tblPersons.PersonID = " & Me!txtpersonID & _
?

[Seth Schrock]

Good catch BTW. You are correct the equals sign should be inside the double quote.

[bseymour12]

To Seth and others:
Thank you so much for the advice! I have an extensive resource "the 2007 access bible" or something of this nature. In the debugging section, it says something about the immediate window and the ? command but does not refer to anything else about the process. From the context of this manual, there is no way that one could surmise what you suggested to do. By the way, I did have the correct syntax on the 'where' statement; I must have accidentally misplaced the " inside of the = sign right before copying. The code runs great though. I was not initially getting the extra space requirement when I tried to ready sequel string for VBA consumption. I have programmed a little in c++ (only structured programming) and this object-oriented process takes some getting used to! Thank all of you for your assistance. Sorry for the long-winded reply.

[NeoPa]

Your posts are fine.

BTW. You may find some more help on debugging in Debugging in VBA.