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