By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Access 2000 Report - trouble with data entered in subforms

P: 2
Hi everyone, basically my problem is this:

I am using an Access 2000 format.

And--I have four subforms in my main form. (Purpose of this is to track projects.) So in my main form I enter the project name, one primary point person for it (1:N list from a separate table), other details, and a manually entered tracking number, which is the primary key.

Now, I also need to put down the legal entities, business managers, financial controllers, and supporting staff, and since these just come from the same pool of people I decided to use subforms for them so I'd only need to type in their names once in the separate table and just select them on the main form if i need them. The subforms are properly working -- they allow me to select one or more entries for the other. Form's working perfectly too.

My problem is that the report I build--no matter how i group or sort!--displays only ONE entry from those four subforms/subtables, and then repeats everything until all the combinations have been entered. Say I have this Project Alpha, with Bob as my point person. For legal entities involved in this Project Alpha I have Entity A, and Entity B, and for business managers I have Manager R and Manager S, (and say we leave the others blank.). I have other details of course but, essentially this is what happens on the report, and where I have problems with using subforms:

Project Name: Project Alpha
Point Person: Bob
Tracking Number: 89554


Legal Entities Involved: Legal Entity A
Business Managers Involved: Manager R


Project Name: Project Alpha
Point Person: Bob
Tracking Number: 89554


Legal Entities Involved: Legal Entity B

Business Managers Involved: Manager S

Project Name: Project Alpha
Point Person: Bob
Tracking Number: 89554


Legal Entities Involved: Legal Entity A
Business Managers Involved: Manager S

Project Name: Project Alpha
Point Person: Bob
Tracking Number: 89554


Legal Entities Involved: Legal Entity B
Business Managers Involved: Manager R



.... :confused: The same project has four separate entries on the report just because I had two legal entities and two business managers selected in the subform! Imagine how many repititions I have with having multiple financial controllers and supporting staff... so I don't know what to do since I still want to retain the subform structure in the report. (I could just put multiple fields in the original table but this would defeat the purpose of access).

Anyone out there have this same problem before? I can't use the "view by" mode used in Access 2003 since I am formatting this using Access 2000 for an office that can't upgrade all its computers to '03. Not that that would matter, would it? : (
Aug 19 '06 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Have you tried using sub reports in the same way you used sub forms.
Aug 19 '06 #2

P: 2
? ooh boy. okay i have never even heard of subreports before. I had a similar project in school where i only had one subform and it worked perfectly. Then I worked from there to create this database, i'm glad i posted here. Thank you so much! I'll look into it but it seems to solve my problem from what I can tell.
Aug 19 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.