How do I trace report data back to its source?

[Ash]

I have a report that shows what clients we bill for each
month based on factors entered into a form. For whatever
reason one client's info is not appearing on the form.
His information seems to have been entered properly. What
I want to know is, how do I check the source of the data
that is displayed on a report so that I can troubleshoot
this? Is there some sort of "reverse wizard" that I can
use?

Thanks in advance...

 

[Brendan Reynolds \(MVP\)]

Open the form in design view. If the Properties window is not visible,
select Properties from the View menu (or use the keyboard shortcut
Alt+Enter). Select the Data tab in the Properties window and the Record
Source property is the first property in the list. Select that property and
click the build button to the right of the property and you can view the
query the report is based on in query design view, SQL view or (as long as
the form that provides the criteria is open) in datasheet view.

Check the Filter and Filter On properties of the report as well (also on the
Data tab in the Properties window).