Getting to SQL in report record source

[Monterey_Manzer]

Hello Everyone,

I am hoping this doesn't require dismantling the report I've generated. Here is my situation. I have a report for which I wrote a subroutine that filters the record source. To avoid having to retype the SQL statement selecting the fields I had built into the initial report, I simply copied and pasted the SQL statement that was the original record source (minus the WHERE clause that my code adds to filter the records). However, I apparently hit an extra key that changed the statement. Now, whenever I am in Design View and I try to edit the record source I get the following error message:

"Missing ), ], or Item in query expression 'GandHtracker.[SMART ID] = PartInfo.[SMART I'."

Now I can clearly see what it is that needs to change and I know exactly what it should say. The problem is that after I click "Okay" I do not get the query in either the QBE or SQL format. The above issue doesn't seem to be causing any problems at present since my filtering code replaces the record source SQL statement with one that is correct, but I'd like to clean it up just the same. Anyone know a sneaky way to get at the SQL code?

Thanks!

[RuralGuy]

In design view, what do you have in the RecordSource property of the Report?

[Monterey_Manzer]

Wow, that was an easy fix. I went in through the RecordSource property (didn't even think to look there) and it took me straight to the query. Oddly enough the problem it gave me was not there and when I navigated out I no longer had the previous difficulty in getting to the record source through the Field List (my previous method). Thanks!

[RuralGuy]

Glad we could help.