Help debugging DLookup query SQL

[Noob]

Greetings,

I just inherited this DB because I know VBA. The original author didn't leave many notes if any. I am trying to step through the code & figure out what they did. Everything has been going smooth till today. My problem is that strsql has no value till I step through this line & once I do I have a huge SQL query.

'Subroutines to change query SQL
strQRY_Name = "Some Query Name"

strsql = Nz(DLookup("QRY_SQL_Template", "ZTBL_Query_Execute", "QRY_Name='" & strQRY_Name &"'"), vbNullString)

I looked at the table but I cant figure out where it is pulling the data to make the huge SQL statement. I dont know Access that well & I am hoping one of you seasoned pros can tell me how they would go about figuring this out if you were in my situation.

TIA

NooB

[pbaldy]

If you're seeing the first bit of the SQL in the table, the rest is likely below. Try expanding the size of the grid, or hitting the down arrow while in field.

[Noob]

So SWEET!!!! You are the BOMB!!!! Thx a TON

[pbaldy]

Happy to help and welcome to the site by the way!