Combobox filtering on a continuous form

[tfossum]

I have a continuos form that has two comboboxes on it. Classic example of the
selection made in cboBox1 filters the available options in cboBox2. No
problem with the old SQL and requery command in the cboBox1's After_Update
event. The problem is that when I am on the next record on the continuous
form the updated selection criteria, which I only want to affect my current
cboBox2, affects the "display" of all other cboBox2 records. Making them
appear to lose their values. On a table level this doesn't happen, however
its a little (well, a lot) disconcerting to the user.

Example:
________________________
cboBox1 | cboBox2|
----------------------------------
MajorCode1 |Value A |
----------------------------------
MajorCode1 |Value B |
----------------------------------

....then

__________________________
cboBox1 | cboBox2 |