 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / January 2008help with requery or refreshing criteria changes
Hello, I have a continious form named frmSuperlog thats control source is a query named qryDailySuperlog. In the forms "Form Header" I have a date picker with a text box named txtSuperlogDate that holds the date and I have a combo box named cboSupervisor that gives me a list of supervisors names. These two boxes are used to filter the query. In the cboSupervisor(s) afterUpdate I have it run the query. My question is every time I choose a new name from my combo box it changes the data in the continious form which is what I wanted but when I change the date I have to reselect a name in the combo box for all the information to change on the form. How can I fix this to where if I change the date it runs the query and if I change the name in the combo box it runs the query? Thanks! Chad It sounds like you already have an AfterUpdate routine that runs for your combobox. You could either create one that runs (as AfterUpdate) for your date-picker, or you could, in the date-picker's AfterUpdate event, call the combobox's AfterUpdate, with something like (your controlnames will vary): Call Me!YourComboBoxName_AfterUpdate() Good luck! Regards Jeff Boyce Microsoft Office/Access MVP > Hello, I have a continious form named frmSuperlog thats control source is > a [quoted text clipped - 17 lines] > > Thanks! Jeff, I think I have this form all messed up. Here is what I want to do. I want to have a form that has a text box that would hold a date and a cbo box that you could select a supervisors name from and when eather box is change then it would change the data in the detail section of my form using a query. do you know of any examples I could look at that does something similur? Thanks!  SignatureNewbies need extra loven......... > Chad > [quoted text clipped - 32 lines] > > > > Thanks! Chad If the "data in the detail section" updates after selecting a new supervisor in the combobox, that combobox probably has an "AfterUpdate" event that tells the data source to either requery or refilter. My suggestion was to add either a similar bit of code to the AfterUpdate of your text box (date picker) or to add a Call statement to (re-)run the cbo's AfterUpdate event. What happens when you try those? Regards Jeff Boyce Microsoft Office/Access MVP > Jeff, I think I have this form all messed up. Here is what I want to do. I > want to have a form that has a text box that would hold a date and a cbo [quoted text clipped - 50 lines] >> > >> > Thanks! nothing happens! I have this same question posted in another form with an attachment of the form and its query. Mabe you can look at it? I just want it to run the query every tim eather the text box or the cbo box is changed and its semi working that way but I think im doing it wriong... Thanks! (Link Below) http://www.access-programmers.co.uk/forums/showthread.php?t=141201 Post the code you are using in the text box's AfterUpdate event. Regards Jeff Boyce Microsoft Office/Access MVP > nothing happens! I have this same question posted in another form with an > attachment of the form and its query. Mabe you can look at it? I just want [quoted text clipped - 5 lines] > (Link Below) > http://www.access-programmers.co.uk/forums/showthread.php?t=141201 Jeff, Access World Forums resolved it. It works with adding a requery to the date pickers "Ok" button. Thats whats bad is I cant show nobody my issues in this forum and sometimes its hard to understand what someone is talking about because you dont see it. I always get a fast answer from this forum and appreciate everyones responces to my questions the help is greatly appreciated! Thanks! SignatureNewbies need extra loven......... > Post the code you are using in the text box's AfterUpdate event. > [quoted text clipped - 12 lines] > > (Link Below) > > http://www.access-programmers.co.uk/forums/showthread.php?t=141201 |
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.