paramediceducator
Technical User
Hello All,
I hope this question is not to basic, I am learning everyday, but is taking some work. Here is the question.
I am using a list box to serve as the search criteria for a tabbed form. In other words, the user goes to the list box, sorts through the last names, selects which ones they want, hit go, and the tabbed form opens with just those people selected. The problem is they have to look through several hundred names. I would like to limit the names in the list based on two combo box selections. One of the combo boxes drops down and allows the user to select current or not current. The other combo box drops down to select what program the users are in. Based on those selections I would like only the applicable names to appear in the list box. Additionally, I would like all of the names to appear if the user selects nothing form either combo box. The user then makes the selection of names they wish and clicks go.
All three fields I am using to sort information are located in a table called "StudentInformation".
The first combo box is called cboStatusselect and it gets its list information from a table called "Status".
The second combo box is called "cboProgramselect" and it gets its list information from a table called StudentProgram.
The list box is called "lstusernmaeselect". Once the selections are made, it opens a form called "StudentInformationTabbedForm".
I hope someone can shed some light on it for me. Thanks, Brian
I hope this question is not to basic, I am learning everyday, but is taking some work. Here is the question.
I am using a list box to serve as the search criteria for a tabbed form. In other words, the user goes to the list box, sorts through the last names, selects which ones they want, hit go, and the tabbed form opens with just those people selected. The problem is they have to look through several hundred names. I would like to limit the names in the list based on two combo box selections. One of the combo boxes drops down and allows the user to select current or not current. The other combo box drops down to select what program the users are in. Based on those selections I would like only the applicable names to appear in the list box. Additionally, I would like all of the names to appear if the user selects nothing form either combo box. The user then makes the selection of names they wish and clicks go.
All three fields I am using to sort information are located in a table called "StudentInformation".
The first combo box is called cboStatusselect and it gets its list information from a table called "Status".
The second combo box is called "cboProgramselect" and it gets its list information from a table called StudentProgram.
The list box is called "lstusernmaeselect". Once the selections are made, it opens a form called "StudentInformationTabbedForm".
I hope someone can shed some light on it for me. Thanks, Brian
