Report results based on Form/Subform

[houstonbill]

I am at a mental impass here and looking for advice. Have a "UserTble" that is populated with User Name, name, email address, BadgeID etc taken from the Corporate datafiles via a module at startup, specific to each person and their PC. It remains constant on the table unless someone else logs into the machine. Have a "suggestion table" that carries detail based on form entries, with a badge ID field linking to the UserTable. Both of these tables make up the "Suggestion Form" used for input. Each time the user opens the suggestion form, the user information from the user table populates the form built on the same table. A subform is then added built on the "suggestion table". From an Administrative standpoint, if I try to run a report of all suggestions, I can do so from the Suffestion table, but the only user detail is that of "badgeID". I cannot figure out how to have a table that will pull all the user detail specific to each suggestion # based on my form/subform set up. Since the UserTable currently has no more than one name (my name on my machine) I cannot pull names from that table. Doe anyone have an idea how I can associate all the user detail for each suggestion listed on the suggestion table?

 

[dhookom]

Why doesn't your UserTble contain all names? If there aren't all names, you can't report all names. You can always limit the UserTble to a single name with a query or whatever.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[houstonbill]

Appararently that is how the code is written at startup. I used several different samples to arrive at what I have now. When each person opens a copy, it is almost like their own private DB. I was looking to see about a way to take all this individual data and download to a main table to be used for Administrative reporting. Guess I will need to relook at that and see if it can be written in such a way as to capture all the detail.