Grouping Separate Fields

[dsellers1]

So I have a form that has five drop downs with corresponding text fields. Each of the drop downs pull from the same row source and gives the user the option to pick between 50 separate tasks. The text field would house how many of that specific task they completed. Instead of making a subform that could be added on the main form, I chose to go this route due to separate calculations on the main form. This makes my table have headers similar to: Combobox1, Text1, Combobox2, Text2,...Combobox5,Text5.

I know this is not ideal but I felt I had to go this route or it would result in making a default field for all 50 tasks

Is there a way to group Combobox1 and Combobox2 (as an example) if they have the same data? If not, any suggestions on how to better the scenario?

 

[dsellers1]

For anyone that runs across this scenario later down the road - I ended up creating 5 queries, one for each Combo/Text box combination. Then a simple union query and it worked fine.

It's still probably not the cleanest idea but it works. Feel free to post any other alternate ways that could be better