Combobox as control source

[gazsharpe101]

Hi everyone,

I have a situation regarding comboboxes..

Please note that the information isn't stored in a table as it is a company database and I cannot get a new table added onto the back end at the moment so my method is to add the fields into the 'row source' property.

I have a form that is used to issue standard letters to companies using information stored on a database. In the first combobox it is a list of the type of company that the letter relates to, i.e. insurance company, bank etc.

Then, I have a 3 column combobox underneath which shows the number of each individual letter (ID if you like), then who it goes to (insurance company, bank etc) and then the purpose of the letter. For example, the first row looks similar to this in the 'row source' property:

"1";"Insurance Company";"Send enquiry letter"

As there are around 30 letters at the moment, with more to be added, what I want to happen is in the first combo box you choose the relevant type of company and then it filters out all of the letters to that relevant type of company in the second combobox. I have set the second column in the second combobox to be the 'bound column' but I am not sure how to make the value of the first combobox be a filter for the second combobox.

Any ideas...Is anyone else all comboboxed out, I know I am

Thanks for any help it is much appreciated.
Gareth.

 

[burrcm]

Without exploring the combobox issue for the moment, assuming you have full access to your front end, why not create an additional backend for yourself and add the required tables to this? You can link to another db with File - Get external data - link tables, and when the IT guru gets around to it, he can add your tables to the official backend and you can relink.

Chris B

 

[gazsharpe101]

That sounds like a plan..

Do you mean create a separate database altogether and put the data into there or to just add another table onto the front end?

How would you go about that?

Thanks for your quick response I'm surprised you managed to read all of my waffling on in that time.

 

[burrcm]

Yes, I suggest create a new db and link to it's tables. Typically the fronts get replaced without notice if an update occurs, so if you add tables there they may get arbitrarily deleted.

Chris B