Hi All, Hmmm, thought I had this taken care of but....
If we acknowledge all of the new work orders and the combobox is empty and another work order is entered, it's not showing up in the combobox. I have tried placing docmd.requery, docmd.repaintobject, docmd.refresh in every event and still cannot get the combobox to refresh. The only way I can get it to show the new workorder is to close the form and reopen it. What am I missing??? -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, February 03, 2006 12:02 PM To: [email protected] Subject: RE: [ms_access] ComboBox help Hi John - That seemed to work! Thanks a million :) -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 03, 2006 11:20 AM To: [email protected] Subject: RE: [ms_access] ComboBox help There are two ways to do the requery once after each update. 1. In the "Acknowledge WO" button's click event, after the update query runs add two lines of code: Forms.MainForm.ComboBox1.Requery Forms.MainForm.ComboBox2.Requery 2. Here's how I would do it. On the "Show me details" button's click event, add two lines of code after you open the Acknowledgement form: DoCmd.OpenForm "Acknowledge Form" ComboBox1.Requery ComboBox2.Requery John -- John V. Ruff - The Eternal Optimist :-) "Commit to the Lord whatever you do, and your plans will succeed." Proverbs 16:3 -------------- Original message -------------- From: "Mike Bisson" <[EMAIL PROTECTED]> They select a new WO from the NewWOlist combo box and click a button that says "show me details" which brings up the "Acknowledgment" form. This form contains a button that says "Acknowledge WO" which then triggers the update query to change the status of the selected WO from 0 to 1. The Acknowledge form then closes and they are back at the form with the two comboboxes. They then move onto the next new wo in the list (this is where the problem is, the wo they just acknowledged still shows up in the NewWOlist combobox) which is why I want it to requery as soon as they click the arrow to select the next WO. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 03, 2006 11:02 AM To: [email protected] Subject: RE: [ms_access] ComboBox help When do you run the update query? Right after the update query runs is when you should refresh/requery the two comboboxes. John -- John V. Ruff - The Eternal Optimist :-) "Commit to the Lord whatever you do, and your plans will succeed." Proverbs 16:3 -------------- Original message -------------- From: "Mike Bisson" <[EMAIL PROTECTED]> That's exactly what is happening - I have 2 comboboxes on my form, NewWOList and PendingWOList. What happens is, new work orders show up in the NewWOList ("Status" 0 WorkOrders) and are "Acknowledged". Once they are acknowledged, they then become a "Pending" WO ("Status" is updated from 0 to 1 at this point), which means it needs to disappear from the NewWOlist combobox and show up in the "PendingWOlist" combobox. This is all accomplished by updating the "status" of the WO in the table using an update query when the new WO is acknowledged. It's either a status 0 which is New or status 1 which is pending. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 03, 2006 10:34 AM To: [email protected] Subject: Re: [ms_access] ComboBox help Why would you need to requery the combobox each time you press the down-arrow? You should only need to requery a combobox when you actually append/update/delete records in the underlying combobox's row source. John -- John V. Ruff - The Eternal Optimist :-) "Commit to the Lord whatever you do, and your plans will succeed." Proverbs 16:3 -------------- Original message -------------- From: Lonnie Johnson <[EMAIL PROTECTED]> Try in the Got Focus Me.ComboBoxName.Requery Mike Bisson <[EMAIL PROTECTED]> wrote: Hi All, What event should I use if I have a combo box that is based on a query and I need to requery it as soon as I click the down arrow? I've tried using the "On Enter" event, but that didn't seem to work. If I use docmd.requery, will it requery all of my controls on the form? I only want to requery that one combobox. As always, thanks in advance :) ================================== Mike Bisson Manager of IT & Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com --------------------------------- YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Relax. Yahoo! Mail virus scanning helps detect nasty viruses! [Non-text portions of this message have been removed] SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Links YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
