How to filter combo box based on multiple fields

[Chief_Up_Yours]

@ano - I don't think you're understanding my latest problem.
As I stated in port #26, if I'm on record A and change the country, the states field is re-queried and states combo box works correctly.
However, when I position to the next record, the country value is correct, but the states combo box has the states list from the previous record.
I appreciate your uploading your modified DB, but I have no clue what you changed.

[Welshgasman]

Sorry, I can only think that the subform is corrupt.
Try recreating and using that with any code amendments I made.

[ano]

yeah recreate both forms was needed , my example i uploaded works as far i understand, only confused abt city bec i not found city any where.
just amazed that he not try my example and just refer to #26 and that tell me nothing that i can reproduce, unless he has some where trouble wth the city or he use different way of next record

[Welshgasman]

I believe I have cracked it.
Although the combo had the correct value, it was not showing it.

As a work around, add this to the subform

Private Sub Form_Current()
Me.cboState_ID.Requery
End Sub

That then seems to show the actual decriptive value.

[Welshgasman]

Still unable to edit a post.

[Micron]

Because of time-outs? I just edited a post elsewhere, but loading the post was quite sluggish. My download Mbps is 52.4 over wifi, which I think is pretty good (?).

[Welshgasman]

No, I just enter extra text and pres save. It saves the most, but the extra text has gone walkabout.

[Chief_Up_Yours]

@welshgasman - Thanks. It took a bit of tweaking, but that fixed the problem.
I ended up doing a requery on all three cascading combo boxes on the subform.
Marking this thread as solved again.

[Welshgasman]

I think you only need to do it on any cascading.
I think it is because the States for one country can not be in the list, despite the value in the record.
By requerying you refresh for the country and now the States has a record in it's source for the value in the record.