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 <*> 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/
