Using a checkbox to autofill combo box value

[Udaman]

I found this video that gave me a great idea for helping to assign a person to a task by clicking a checkbox instead of having the user select their initials from a combo box for a potential long list of tasks.

Video:
https://www.youtube.com/watch?v=74-Mr-RRaNA

So I have a table that looks like this: (Keep in mind I have 10 such tables for different categories of tasks, with up to 40 tasks per table).

• TaskID - Autonumber (Primary Key)
• UserID - Lookup from Users table
• Task1Inspected - Yes/No
• Task1Serviced - Yes/No
• Task2Inspected - Yes/No
• Task2Serviced - Yes/No

On my form I simply want the user to first choose their initials from a combo box in the Header section (UserID), then when they select a checkbox to have their initials show up in a combo box next to the checkbox, based on the value of the combo box in the Header section.

The linked video shows how I can auto-populate a combo box from another combo box as new records are created, but the format of the instructors tables are far different than mine are, so I am stumped on how to make this work with my table format.

Can anyone give me some tips or any links to a website that can aid me?

 

[GinaWhipp]

Well, the first problem IS your Table set-up. It should be...

tblTasks
tTaskID
tUserID
tTaskServiced
tTaskInspected

Doing it that way will make it far easier to do as the video suggests.