Hi all. I'm relatively new to Access and am not a programmer. I apologize in advance if this question has been addressed in another thread.
I'm compiling in-house information on forests insects and diseases in a database with a main dashboard form used for searching individual species (there is a separate DATA ENTRY form that works very well). The Pest Database form is controlled by a main combobox "Select Pest" to search records by pest ID. I have a subform for survey protocols that also works well. The "Select Type" combobox works like a filter, allowing users to view details on only one type of survey for the selected pest. My only issue, is that the "select type" combobox shows all possible survey types for all species (see photo attachment 2). It would be nice if the combobox only listed survey types available for the specific pest (i.e., the selected record of the main form).
If the only solution here requires a bit of code in an event, please explain your proposed code in detail.
Attached screenshots are of my main "Pest Search" dashboard - the "Survey Protocols" section is the subform in question. The second image is of the subform, showing the drop-down combobox that controls which survey type is shown.
**Alternatively, I'd settle for a separate list box (or similar control) that simply lists "survey types available". I know I could acomplish this with a seperate subform, but that would be really ugly (see my "Hosts" subform for an example of an ugly list ).
Thanks!!!
Justin (Fredericton, NB, Canada)
I'm compiling in-house information on forests insects and diseases in a database with a main dashboard form used for searching individual species (there is a separate DATA ENTRY form that works very well). The Pest Database form is controlled by a main combobox "Select Pest" to search records by pest ID. I have a subform for survey protocols that also works well. The "Select Type" combobox works like a filter, allowing users to view details on only one type of survey for the selected pest. My only issue, is that the "select type" combobox shows all possible survey types for all species (see photo attachment 2). It would be nice if the combobox only listed survey types available for the specific pest (i.e., the selected record of the main form).
If the only solution here requires a bit of code in an event, please explain your proposed code in detail.
Attached screenshots are of my main "Pest Search" dashboard - the "Survey Protocols" section is the subform in question. The second image is of the subform, showing the drop-down combobox that controls which survey type is shown.
**Alternatively, I'd settle for a separate list box (or similar control) that simply lists "survey types available". I know I could acomplish this with a seperate subform, but that would be really ugly (see my "Hosts" subform for an example of an ugly list ).
Thanks!!!
Justin (Fredericton, NB, Canada)