 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2008User has to toggle filter to see data after combo update
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 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 [quoted text clipped - 5 lines] >if I open it in Access 2003. > Mich 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 [quoted text clipped - 10 lines] >>problem if I open it in Access 2003. >> Mich 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 >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 [quoted text clipped - 10 lines] >>problem if I open it in Access 2003. >> Mich 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 [quoted text clipped - 10 lines] >>problem if I open it in Access 2003. >> Mich Did you really need the requery? > Finally got it working using: > [frmAssignmentDetail subform1].Form.FilterOn = True [quoted text clipped - 14 lines] >>>not a problem if I open it in Access 2003. >>> Mich 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: [quoted text clipped - 16 lines] >>>>This is not a problem if I open it in Access 2003. >>>> Mich Thanks, just curious. Pete > If I don't requery it keeps the info from the previous combo choice. > [quoted text clipped - 18 lines] >>>>>This is not a problem if I open it in Access 2003. >>>>> Mich |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.