Question Work out what queries/macros are being used

[weevil]

Hi there,

I am reasonable at creating access databases, but I have inherited a rediculously complicated (by my standards) access database created in the stone-age. It works fine in Access 2010 which is what i am using.

I have a report which i want to change around, but i need to assertain what queries/macros are being used to create the data this report calls, as directly referencing the data i want to add to this report gives me an error.

How do i find out what queries/macros are being used in a given form/report ?

Many thanks.

 

[PaulO]

Go into DESIGN mode in the report, load the Properties, and look at the Record Source on the Data tab (probably a Query)

 

[weevil]

i am looking i the record source, and it's simply a list of certain fields coming from somewhere, like a query i agree it probably is, but i cannt seem to find which query, as there is about 20 of them. It just lists the field names themselves and not where they are coming from.

 

[PaulO]

I think you are looking at available FIELDS to pull into the report rather than the RECORD SOURCE feeding the report ...