Comparing Company Info

[Bvincey2002]

I am a novice with access and I am working with access 97. What I am trying to do is create a fourm that will pull up company history and then use the data to create a report. How I have the form set up so far is a combo box with a list of the company names and I want to subform to pull up all of the history for the first company. Then a second list box and sub form for the second company. From there I want to take that history from both sub forms and put that data into a report using a button. Is this even possible? If so could some one help me with this project?

[orange]

Please tell us about your tables.

[Bvincey2002]

The information is all comming off of one Order History table. The combo box is pulling from another table that has all my accounts listed.

[Bvincey2002]

Orange,

Do you need more information than that? What I want to do is have the combo box list the company names and then in the subform pull up that companies history. I have only one Table that all my information is being pulled from but combo box information is comming from a query derived from that one table.

[orange]

Can you post (in zip format) a copy of your database?

It seems to me from a structure view you should have (at least)
tblCompany
tblHistoryEvents

I'm not clear what the History aspect is all about. Can you describe a typical Company and "all of its History".