Currently, I am using MS Acess for my development. I have two toolboxes (Combo box and listbox). What I want to achieve is to allow the user to select the data from the combo box and list the selected data that corresponds to what have been selected in the combo box. Ex: Inside the combox I have three data (studentid, name, courses). When the user click on studentid, the courses that he enrolled in will be listed in the listbox, which meant that the corresponding values from the tables databases will be displayed. I am certain that VB Acess can achieved but nt sure as to how to program that. It will be very much appreciated if someone could provide some code snippets or is there a possibility to achieve that using query. Thank alot!
Search here on "cascading" combo boxes, which is where the choices available in the second combo depend on the selection made in the first. Using a listbox instead of a combobox for the second one won't change the technique.