nancybrown
Well-known Member
- Joined
- Apr 7, 2005
- Messages
- 868
Could someone please help me with a VBA code. I'm new to VBA and have no clue what to write.
I have an employee table that has various fields including a field for employee competencies.
I have a second table for jobs with various fields including a field with required competencies.
I have a form that has a combo box to select a job of interest and will need a search to match the top 5 employee competencies to the selected job.
This needs to be dynamic as each job will have different competencies as well as each person having different qualifications. Is a loop required . . . no idea how to do this.
I was instructed to run a query and modify it in SQL view as a top 5, but I'm confused as to how to connect it to the selected job on my form.
Any help would be really appreciated.
I have an employee table that has various fields including a field for employee competencies.
I have a second table for jobs with various fields including a field with required competencies.
I have a form that has a combo box to select a job of interest and will need a search to match the top 5 employee competencies to the selected job.
This needs to be dynamic as each job will have different competencies as well as each person having different qualifications. Is a loop required . . . no idea how to do this.
I was instructed to run a query and modify it in SQL view as a top 5, but I'm confused as to how to connect it to the selected job on my form.
Any help would be really appreciated.