User has to toggle filter to see data after combo update

[M Skabialka]

I have a database that was designed in Access XP and used in Access 2003 and
2007. One of my users showed me that in forms with a combo to select the
contents of the subform, nothing shows up after the combo selection is made.
However if they click in the subform, then click the Toggle filter button on
the ribbon, they get the data they wish to see. What command can I use
after updating the combo to perform the toggle filter function so they don't
have to when they view it in Access 2007? This is not a problem if I open
it in Access 2003.
Mich

 

[Pete D.]

I found that the form open filtered was turned on when I first moved form to
2007. Once I corrected it in 2007 and saved form it stopped. Found no rime
or reason to it other then last filter used in 2003 stuck when opened in
2007 first time. Curious to see if you find any other solution.
Pete D.

 

[M Skabialka]

Where do you find this property?

I found that the form open filtered was turned on when I first moved form
to 2007. Once I corrected it in 2007 and saved form it stopped. Found no
rime or reason to it other then last filter used in 2003 stuck when opened
in 2007 first time. Curious to see if you find any other solution.
Pete D.

 

[M Skabialka]

I found "Filter On Load" and it makes no difference whether it is on or off
on the main form or the subform. I still get no records unless I click the
Toggle filter button. I also tried the FilterOnEmptyMaster property to no
avail.
Allow Filters is yes
I also tried all of the following:
[frmAssignmentDetail subform1].Requery
[Forms]![frmAssignmentDetail]![frmAssignmentDetail subform1].Requery
Me.Requery
Form.Requery
Me.Refresh
DoCmd.ShowAllRecords
etc

 

[M Skabialka]

Finally got it working using:
[frmAssignmentDetail subform1].Form.FilterOn = True
[frmAssignmentDetail subform1].Requery

 

[Pete D.]

Did you really need the requery?

Finally got it working using:
[frmAssignmentDetail subform1].Form.FilterOn = True
[frmAssignmentDetail subform1].Requery

I found that the form open filtered was turned on when I first moved form
to 2007. Once I corrected it in 2007 and saved form it stopped. Found no
rime or reason to it other then last filter used in 2003 stuck when opened
in 2007 first time. Curious to see if you find any other solution.
Pete D.

 

[M Skabialka]

If I don't requery it keeps the info from the previous combo choice.

Did you really need the requery?

Finally got it working using:
[frmAssignmentDetail subform1].Form.FilterOn = True
[frmAssignmentDetail subform1].Requery

I found that the form open filtered was turned on when I first moved form
to 2007. Once I corrected it in 2007 and saved form it stopped. Found no
rime or reason to it other then last filter used in 2003 stuck when
opened in 2007 first time. Curious to see if you find any other
solution.
Pete D.
I have a database that was designed in Access XP and used in Access 2003
and 2007. One of my users showed me that in forms with a combo to
select the contents of the subform, nothing shows up after the combo
selection is made. However if they click in the subform, then click the
Toggle filter button on the ribbon, they get the data they wish to see.
What command can I use after updating the combo to perform the toggle
filter function so they don't have to when they view it in Access 2007?
This is not a problem if I open it in Access 2003.
Mich

 

[Pete D.]

Thanks, just curious. Pete

If I don't requery it keeps the info from the previous combo choice.

Did you really need the requery?

Finally got it working using:
[frmAssignmentDetail subform1].Form.FilterOn = True
[frmAssignmentDetail subform1].Requery

I found that the form open filtered was turned on when I first moved
form to 2007. Once I corrected it in 2007 and saved form it stopped.
Found no rime or reason to it other then last filter used in 2003 stuck
when opened in 2007 first time. Curious to see if you find any other
solution.
Pete D.
I have a database that was designed in Access XP and used in Access
2003 and 2007. One of my users showed me that in forms with a combo to
select the contents of the subform, nothing shows up after the combo
selection is made. However if they click in the subform, then click the
Toggle filter button on the ribbon, they get the data they wish to see.
What command can I use after updating the combo to perform the toggle
filter function so they don't have to when they view it in Access 2007?
This is not a problem if I open it in Access 2003.
Mich