Associating fields in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, this may sound like a stupid question, but I was working on a report &
I'm not sure what I did but now I've lost field associations/control source.
I am displaying data from several different tables in my 'Detail' section,
but now I can only change my control source to one of the tables, leaving the
fields from the other tables showing errors (Field name not on list). I am
searching books & questions on here but can't seem to find an answer to the
simple question. Can anyone tell me what I 'broke' and how to fix it again?
I appreciate the help
 
Make sure the report's Record Source property contains fields from all the
required tables.
 
When I check the Record Source (right click top left corner & select
properties right?) it lists all the tables. I'm looking at the data tab &
the all tab. If I click on a table (like the one that it can't find fields
for) in Record Source there, then it's like it finds all the fields on that
table instead & marks the other records (from other tables)as not on field
list. Then when I run the report, it asks for values for those fields also.
What did I 'break'?
 
You can create a query that selects fields from multiple related tables. Use
this query for your report's record source.
 
Back
Top