Just a few more humps to get over...
Only using one line of VBA (which I don't know), I was able to accomplish the following:
-Built a form based on a junction table which contains employees, the work areas they're assigned to, the training modules they've completed, & the completion dates for said modules.
-Built an unbound combo box that allows the user to select the work area, hence filtering the form to only show a specific work area (great!).
-To make this happen, I had to add the following line to the After Update event of the combo box: Me.Requery.
-The query itself has the following fields: employee ID, employee name, work area, training module, the work area ID with the criteria based on the selection the user makes from the combo box, & lastly the completion date.
Everything works flawlessly right now; however, the user is going to want to update the completion dates for "certain" training modules & doesn't want to necessarily see every training module that every employee has completed in one shot. Basically, I want to filter the form a bit further; once for the work area (which I've accomplished thus far) & one more time for the training module using another combo box. Hours of searching hasn't helped me yet. Thank you in advance.
Only using one line of VBA (which I don't know), I was able to accomplish the following:
-Built a form based on a junction table which contains employees, the work areas they're assigned to, the training modules they've completed, & the completion dates for said modules.
-Built an unbound combo box that allows the user to select the work area, hence filtering the form to only show a specific work area (great!).
-To make this happen, I had to add the following line to the After Update event of the combo box: Me.Requery.
-The query itself has the following fields: employee ID, employee name, work area, training module, the work area ID with the criteria based on the selection the user makes from the combo box, & lastly the completion date.
Everything works flawlessly right now; however, the user is going to want to update the completion dates for "certain" training modules & doesn't want to necessarily see every training module that every employee has completed in one shot. Basically, I want to filter the form a bit further; once for the work area (which I've accomplished thus far) & one more time for the training module using another combo box. Hours of searching hasn't helped me yet. Thank you in advance.