Connecting Subform to another Subform

[JoeyB]

In my airport database I want to connect two subforms with each other.





I got a mainform which contains a Combo Box with Airports in it. When you select an airport it will show the aircraft movements of a certain year in subform1 and passengernumbers in subform2. I got data for over 28 years. In subform1 I implemented a combo box with years. But when you select years in this Combobox the data for aircraft movements changes but not for passengernumbers.

How can I relate them to each other?

I tried to use the following link in VBA, but couldnt get it to work. http://access.mvps.org/access/forms/frm0031.htm

Gratitude in advance!

[June7]

Try this tutorial http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[JoeyB]

Try this tutorial http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

I have done exactly the same as been told here. But my problem is that I got two cmb boxes. Airport and Year.

Through the tutorial you gave me, I related the subforms by year but not by airport. What happens now it is perfectly fine looking up the airmovements but the passenger numbers wont respond to the airport cmbox. How do I relate the airport to the passenger as well?

[June7]

Not understanding what you are trying to do. Are these forms for data entry? If not, maybe you should really be creating reports.

[JoeyB]

Not understanding what you are trying to do. Are these forms for data entry? If not, maybe you should really be creating reports.

The database must be updated in every year, but that is only gonna be done by the administrator. The database is gonna be published and the ones who are gonna use it will not be put in data.

I am here to learn so excuse me if this is a stupid/ ignorant question, but can the user in the use the reports the same as it would with forms? For example, the user wishes to get information about Toowoomba airport. The user then clicks on a combobox and selects that airport. But I also would like, and my boss wants, to be able to compare airports with each other or with airports from certain states, certain sizes, what kind of operators (council, private, joint or defence). And show diagrams of passenger numbers, airmovements etc.

Hope that is clear enough, and thank you for your time!

[June7]

Primary purposes of forms are for data entry and interface to manage the database. Queries and Reports are intended to manipulate and output data.

Select airport in combobox and open report with data about that airport. If you have the data, you can compare anything you want.