Filter problem

[cbende2]

Hello all,

I have a form that displays in datasheet mode.

I have about 20 fields, field1-field20 in Table1.

Let's say 4 of my fields(Field1-Field4) are FK's.

I use comboboxes to display the appropriate info of the FK instead of listing the number that is stored in Table1.

When I go to apply a filter to Field1, it works. However when I go to apply a filter to Field2, It gives me a message saying it cant find Field1. It gives me this message twice, and then I'm able to set the filter on field2. If I then try to filter Field3, I get the same message, although now I get 2 messages for Field1 saying it can't find the field, and I get 2 messages saying It can't find Field2, and then I can set the filter for Field3.

I can't seem to figure it out. The first filter works fine on any of my fields, however, once I go to add another filter to another one of my fields it says it can not find the field I first filtered.

Thanks

[June7]

These are cascading comboboxes? Need to review properties of each combobox. If you want to provide db ...