Hi,
Can anyone help?
I have an active X control which has 6 combo boxes amongst other controls on it.
Each combo box is populated with the same data i.e. types of customer.(owner,dealer,etc)
I want to create a function to populate text boxes with the results of an SQL statement based on what is selected in the combo. e.g. When owner is selected I search the DB for an owner and populate the owner name text box with the result. I should be able to choose a different customer type for each combo and populate the text boxes accorrdingly or drag these details from another screen.
I want to do all of this in the one function. Is this impossible or just too messy? Can anyone give me any help on how to achieve this as I'm new to this game.
Thanks
Can anyone help?
I have an active X control which has 6 combo boxes amongst other controls on it.
Each combo box is populated with the same data i.e. types of customer.(owner,dealer,etc)
I want to create a function to populate text boxes with the results of an SQL statement based on what is selected in the combo. e.g. When owner is selected I search the DB for an owner and populate the owner name text box with the result. I should be able to choose a different customer type for each combo and populate the text boxes accorrdingly or drag these details from another screen.
I want to do all of this in the one function. Is this impossible or just too messy? Can anyone give me any help on how to achieve this as I'm new to this game.
Thanks