Hello there I am fairly new to programming in access 2007 and its been a while for vba. Here is my issue:
I have a form(NewBusTaskEntry) that has a combobox "nbquestion" This pulls value in from a table " NewBusAcqQuestionCategory" This list the categories that vaious questions fall into.
I have a subform which is populated by a query. This query consists of two tables linked together by a NewBusAcqQuestionCategoryID which matches multiple questions. I have the query defined and have specified in the criteria of the query to reference the combo box ([Forms]![NewBusTaskEntry]![nbquestion])
My question is what do I need to do to get the subform to populate with the questions related to the category selected in the combobox.There are more fields than just the questions in the subform but those relate to the questions.
The end result I am looking for is the user selects a category from the combobox, the subform populates, user populates rows in subform and saves the information and that would save to a table and then clears the form.
thank you for any help
I have a form(NewBusTaskEntry) that has a combobox "nbquestion" This pulls value in from a table " NewBusAcqQuestionCategory" This list the categories that vaious questions fall into.
I have a subform which is populated by a query. This query consists of two tables linked together by a NewBusAcqQuestionCategoryID which matches multiple questions. I have the query defined and have specified in the criteria of the query to reference the combo box ([Forms]![NewBusTaskEntry]![nbquestion])
My question is what do I need to do to get the subform to populate with the questions related to the category selected in the combobox.There are more fields than just the questions in the subform but those relate to the questions.
The end result I am looking for is the user selects a category from the combobox, the subform populates, user populates rows in subform and saves the information and that would save to a table and then clears the form.
thank you for any help
