"filter" is not always filtering

[lubbs65]

So i have a bunch of combo boxes for an input form. When we go through someone's data we often use the filter command. when you hit filter, you can see the list of everyone.

The same thing is applied for codes we use. We would do a search for codes by hitting filter, then scrolling down to the code we want. Recently, when I hit filter on this "codes" combo box the filter command comes up with the option "sort a-z" but never lists any of the codes (it used to, but now it doesn't for some strange reason). Is there a way to get that list to re-appear?

 

[jackd]

You are asking questions of your specific code, but you haven't shown us any code.
It would appear that something has changed. Perhaps something is corrupted (perhaps not).
Have you done a compact and repair?

Did you want to show some of the code involved?
Can you put in some breakpoints to narrow down the issue?

 

[lubbs65]

update:

I figured out the cause, but I still need the solution:
My input form uses combo boxes that associate for 2 forms.
I've added fields to "Table A" in my form I added text boxes to include these fields. My form also uses a combo box which contains data from "Table B". this is the particular field that I can no longer filter in the form. Once I add the new fields from "Table A" into the form, the filter ability i described above goes away for the field that is chosen in Field .
The strange thing is that I also have fields that are from "Table C". I can still properly filter these fields after the change is made.

How can I fix this?

 

[jackd]

How are the combo boxes related/used? I'm not following your description.

Do you have a cascading combo set up? Pick from combo1 and that changes/determines what's available in combo2...?

 

[lubbs65]

here is a picture of my problem in a nutshell:

okay, so the one that filters correctly i labeled "names" which is on the left. Names is part of a table named "Table C" Codes meanwhile is part of table"table B". At the bottom is the message that popped up when i attempted to add the fields that I added from "table A" into the form.

So say in table A i recently added the field "types of vegetables"
All is well in the form after adding that field.
Once i add the field to the form however it gives me that message and then the Field for "Table B" can not properly be filtered.

Here is the mapping for the query that exists in the message:

 

[lubbs65]

Table D was not mentioned yet: it too is contained in the in the input form.

strangely though, I can filter the fields for Table D like I can for Table C and Table A. Table B is being a problem for almost no reason.