One combo box changing another - partial success

[Access101]

I have applied the following solution wherein a choice in Combo box A changes
what's available in Combo box B, and it works fine.

However, after updating record two and returning to record one, I see that
the actions I took in record two have effected teh combo boxes in record one.

At first, I thought it was a continuous form problem, but it persists after
changing to a single form.

Any help is appreciated.

 

[Chegu Tom]

I suspect you are using the AfterUpdate event in Combo Box 1 to set the row
source query for combo box 2

Try instead to use the ONEnter event of combo box 2 to set the row source
for combo box2 based on the parameters found in combo box 1 for that same
record. It will reset the rowsource every time you neter box 2. Not just
after you have chaged box 1

Tom

 

[Access101]

I appreciate your quick response. I'll give it a try. Just to be clear.

I am in record 1
I change CmbA to Beverages
CmbB refreshes to Water, Pop, Tea
I choose WATER

I go to record 2
I change CmbA to Fruit
CmbB refreshes to Apples, Oranges
I choose ORANGES

Now I go back to record 1
CmbB has been blanked out - because of the actions I took in Record 2

I'll try your method in the meantime.

There's another method on this Microsoft site which doesn't use rowsource,
but uses the AfterUpdate event:

http://office.microsoft.com/en-us/access/HA011730581033.aspx

 

[Chegu Tom]

The method on the microsoft site actually uses rowsource but does not use an
event. It uses a query with a variable criteria taken from the form. It
should work as well.

Tom