If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Associating fields in a report
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 -- Cheryl |
#2
|
|||
|
|||
Associating fields in a report
Make sure the report's Record Source property contains fields from all the
required tables. -- Duane Hookom MS Access MVP -- "Cheryl" wrote in message ... 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 -- Cheryl |
#3
|
|||
|
|||
Associating fields in a report
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'? -- Cheryl "Duane Hookom" wrote: Make sure the report's Record Source property contains fields from all the required tables. -- Duane Hookom MS Access MVP -- "Cheryl" wrote in message ... 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 -- Cheryl |
#4
|
|||
|
|||
Associating fields in a report
You can create a query that selects fields from multiple related tables. Use
this query for your report's record source. -- Duane Hookom MS Access MVP "Cheryl" wrote in message ... 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'? -- Cheryl "Duane Hookom" wrote: Make sure the report's Record Source property contains fields from all the required tables. -- Duane Hookom MS Access MVP -- "Cheryl" wrote in message ... 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 -- Cheryl |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Comboxbox Value(s) into a report field(s) | Amour | Setting Up & Running Reports | 2 | September 15th, 2005 06:01 PM |
No current record 3021 | hughess7 | General Discussion | 30 | August 19th, 2005 04:39 PM |
Has anyone seen this behaviour? What might it be? | tw | General Discussion | 4 | June 30th, 2005 03:23 PM |
"Too Many Fields Defined" - in Report, but not in Form!!! | Rob Parker | Setting Up & Running Reports | 0 | May 9th, 2005 02:17 PM |
Multi-column report with text from separate fields flowing down each column | Rabi Tripathi | Setting Up & Running Reports | 3 | September 30th, 2004 03:23 AM |