Combo box option depending on previous combo box value & having to draw data from diff data table
Hi guys,
I am having this problem,
I managed to get the 2nd Combobox (Combo16) to filer it's options based on the value selected on the 1st combobox (Combo 14) However for this two data table relationship, it is a one to one relationship. Whereby I have a table of (List of Countries) and a table of (Customers List) in various countries.
Now the issue is with the third combo box. (Combo18). After selecting the Countries and the Customers, I want to be able to select the different sites that the customer have. The way I have structured the data table is that one customer would have one data table of sites. Because lets say I sell computers to Carrefour in Germany, Carrefour will have different shopping outlets at Berlin or other cities.
I want to be able to only show the sites that the client that I have chosen in Combo 16.
The code that I have used for Combo14 to Combo16 is the requery code
=========================
Private Sub Combo14_AfterUpdate()
Me.Combo16.Requery
End Sub
==================
The second issue I would have is that after selecting the Sites, I would want to print the equipment list that the outlet has, like their POS system, their computers, their logistics provider. Correct me if I am wrong, this should involve a button to print the report in pdf form? But how do I only print the site record that I have selected in Combo18 ?