Odd problem - I'm guessing there's a simple solution? (has to do with continuous forms, row source, and control source)

[zzzjoshzzz]

Right now my boss has a form (ok it's a subform) that just has two combo boxes. The first is a selection of A, B, or C. The second has a selection of Xa, Xb, or Xc - where X is what the user chose in the first combo box.


If a user selects A then Ab for the first record in this continuous scrolling subform, then selects B for the second record, Ab disappears in the first record (Because it's no longer available as a row source). However, Ab is still stored as the first record's value, it just is blanked out within the form. The user then selects Ba for the second record.


THE QUESTION:
Is there some way to allow the end user interact with the second form, selecting B and then Ba while being able to see the Ab previously selected in the first record?

 

[xenou]

This would depend on the actual mechanics involved that are creating this behavior. Can't say for sure without more details. Can you give a more clear example. I'm not sure I am able to visualize this accurately from the description above. What are the actual choices being made, and what does the user then actually see as a result?
ξ