I have a form in which one combo box's options are dynamically updated based on the selection of the first combo box. I want this form to exist in datasheet view. The combo boxes in datasheet view essentially become columns so the goal is to have a selection in column one impact the options for column 2. The query I am running to change the options for column 2 is tied to the entire combo box so a change made anywhere in the first column impacts all the previous rows for the second column. Here is an example:
Add an entry in row 1 of form. Select Role for Skill Category which presents me with the correct options for Skill Description.
Add another entry for row 2 with Skill Category as Role. Everything still works as expected
When I move to row 3 I select domain for Skill Category. The options in Skill Description are correct but it removes the previously selected options for rows 1 and 2.
Lastly, when I add a 4th row and select role it removes the Skill Description from row 3 but the Skill Descriptions for row 1 and 2 reappear.
Appreciate any and all help,
Thanks