After a great suggestion from the community yesterday I am now one step forward into completing my task . Yet I am facing another problem which I am unable to solve myself because I still lack alot of knowledge of Access.
First lets say I have a table named Table1 with the following structure:
First comb box merges data from [Table1].Data (if value [Table1].Name equals "LOCATION") into unique lines and displays it in the combo box.
Second combo box contains mail adresses. Point is, I have yet no clue how I can link this one to the first since making the selection depend on dropdownbox1 will make it display the LOCATION in combo box 2.
The goal is to make selection one hit all locations, if one location is being selected, for example Sydney then combo box 2 (containing mail adresses) must look at the (possible) LOCATION filled out in combo box 1 and should then display ALL the mail adresses the table knows corresponding to the set LOCATION in combo box 1 .
I have started thinking about making it check for location according to combo box 1, then drop down a certain amount of rows lets say x , hop over to a specific column and copy the data that is present in that box. Point is with a massive file I cannot make it static at all.
Please mind that my knowledge of Access is still rather small and therefor the terms I use could be totally wrong
. Trying to learn it as fast as I can!
Take care.
First lets say I have a table named Table1 with the following structure:
First comb box merges data from [Table1].Data (if value [Table1].Name equals "LOCATION") into unique lines and displays it in the combo box.
Second combo box contains mail adresses. Point is, I have yet no clue how I can link this one to the first since making the selection depend on dropdownbox1 will make it display the LOCATION in combo box 2.
The goal is to make selection one hit all locations, if one location is being selected, for example Sydney then combo box 2 (containing mail adresses) must look at the (possible) LOCATION filled out in combo box 1 and should then display ALL the mail adresses the table knows corresponding to the set LOCATION in combo box 1 .
I have started thinking about making it check for location according to combo box 1, then drop down a certain amount of rows lets say x , hop over to a specific column and copy the data that is present in that box. Point is with a massive file I cannot make it static at all.
Please mind that my knowledge of Access is still rather small and therefor the terms I use could be totally wrong
. Trying to learn it as fast as I can!Take care.
