I am creating a small database for the police at the facility which I work. They wanted a cascading style using combo boxes that displays a subclass(cboSubClass)of offences populated after selecting a value from the main combo box called (cboClass). I have succeeded in this task by making multiple tables populated with subclasses and writing a SELECT CASE structure in VBA to populate the combo box(cboSubClass). NOW, There are so many Classes and SubClasses that I think it would be much easier to create ONE table with Classes and SubClasses and use an SQL statement to filter through the selections. My problem is that I have tried to write the code for this but it is not working. I will include the database in the files folder with what code I have in the Record sourse section of the main combo box and the After update statements that I have written. Any help to accomplish this task would be greatly appreciated. The name of the file is: Case Assignment Register TEST
Thankyou
Paul
Tidak ada komentar:
Posting Komentar