G
Gary
I made a 3 level SubDataSheet. The top level is a table, the 2nd and 3rd
level are queries. The Table is linked to the 2nd level query, and the 2nd
level is also linked to the 3rd level query.
Within each query, I have a "where" condition on each. I am using Like (to
an combo box on the top level form).
I select which filtering I want from the combo box (on the top level form).
If I select a value from the list with no wildcards, everything works with no
problems.
If I enter a value with a wildcard (immediately after opening the program)
everything works with the wildcard. I then select a value form the combo
box and everything works. I when repead the wildcard, and this time the link
to the 2nd level and below is not working.
I next minimized the form, and open the database window and select the Table
that the subdatasheets are based on, and its works there!!!
I would also like to point out that after selecting the filter from the
Combo Box, I delete the contains of the top level table and attached a new
data which was based on the Combo Box. (The reason was that I also attach to
the bottom, summary information).
I have been trying for over 2 weeks with no luck.
I have also tried requery the top level, and the 2nd level with no change.
Your help is deeply appreciated.
Thank You,
G
level are queries. The Table is linked to the 2nd level query, and the 2nd
level is also linked to the 3rd level query.
Within each query, I have a "where" condition on each. I am using Like (to
an combo box on the top level form).
I select which filtering I want from the combo box (on the top level form).
If I select a value from the list with no wildcards, everything works with no
problems.
If I enter a value with a wildcard (immediately after opening the program)
everything works with the wildcard. I then select a value form the combo
box and everything works. I when repead the wildcard, and this time the link
to the 2nd level and below is not working.
I next minimized the form, and open the database window and select the Table
that the subdatasheets are based on, and its works there!!!
I would also like to point out that after selecting the filter from the
Combo Box, I delete the contains of the top level table and attached a new
data which was based on the Combo Box. (The reason was that I also attach to
the bottom, summary information).
I have been trying for over 2 weeks with no luck.
I have also tried requery the top level, and the 2nd level with no change.
Your help is deeply appreciated.
Thank You,
G