how would somebody go about pulling data from a combo box to put it on the title of a report

[Zetheroth]

Sales Examples.zipin the attached document there is a form called Buyer Names, on it is a drop down list that almost does everything I need it to do, so far it should update all buyer names queries and then open the buyer names report, I need it to also put the name selected at the top of the report and open the subreports, the rest should be functional but I pieced it together with little knowledge so any help would be appreciated.

[ranman256]

if the combo is bound to query: qsMyData.
then open query qsMyData

[Welshgasman]

What version of Access are you using.?

[Zetheroth]

I have got the name working and the part where the subforms load, now I just need to know if it would be possible to put the combo box on the report that is summerizing everything. Also I need to figure out how to add up numbers from the list and have those numbers on the bottom of the last page, including the sub forms, and they need to then be able to work with each other for example, I need to add up all the purchases, then add all the payments, then subtract the payment total so I get how much is owed, I also need to have a total number of each item purchased and how many of them the

[xps35]

Try [forms]![Buyer Names]![BuyerNames] (with [ ]).

[Zetheroth]

I believe it is 365, its just what downloaded when I got 365

[Zetheroth]

oddly enough litteraly after saving and reloading the document the whole name is the selected from list thing works perfectly

[mike60smart]

Hi

Sorry to say but your design is all wrong.

The Joins between all related tables are showing as "Indeterminate"

You should have an Autonumber PK in every table and in all related tables you should have a FK with a DataType of LongInteger

[Zetheroth]

Ya, I'm fairly new to access, and truth be told I've got no idea what I'm doing, how would I go about doing that and what would it solve?

[Micron]

truth be told I've got no idea what I'm doing

Then may I recommend some homework?

Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.com...on-part-i.html
and/or
http://holowczak.com/database-normalization/

Entity-Relationship Diagramming: Part I, II, III and IV
http://rogersaccessblog.blogspot.com...ng-part-i.html

How do I Create an Application in Microsoft Access?
http://rogersaccessblog.blogspot.com...cation-in.html

Important for success:
Naming conventions
http://access.mvps.org/access/general/gen0012.htm
https://www.access-programmers.co.uk...d.php?t=225837

What not to use in names
- http://allenbrowne.com/AppIssueBadWord.html

About Auto Numbers
- http://access.mvps.org/access/general/gen0025.htm

The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html
About Multi Value Fields - http://www.mendipdatasystems.co.uk/m...594468763.html