?
Solved

access refresh combo box

Posted on 2012-03-29
10
Medium Priority
?
483 Views
Last Modified: 2012-06-27
I thought i could do this but the knack has escaped me.

OK, field on form also features as one of the fields returned in combo box which combo box selects the records in the form.

However when I change the field (its a lookup field) and I would like the combo box to immediately reflect that change when entered.

Its probably an after update/current form event/refresh something or other but Im not doing what I should be doing.

So help please.
0
Comment
Question by:topUKlawyer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37784683
use the afterupdate event to requery the combo box..
0
 
LVL 70

Expert Comment

by:KCTS
ID: 37784786
Agreed - as the last instruction in the code add

me.ComboBoxName.requery

(where ComboBoxName is the name of your combo box)
0
 

Author Comment

by:topUKlawyer
ID: 37785796
Yes but the after event of which control ?
0
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37786632
isn't this an obvious thing, you posted
<However when I change the field (its a lookup field) and I would like the combo box to immediately reflect that change when entered.>

what is that "field" ?
0
 
LVL 20

Expert Comment

by:clarkscott
ID: 37787024
Sometimes, my combobox source table contains more info than shown in the combo.  In these cases, I create a bound "list" form to the combo source table with the ability to add records.  Then, from the DOUBLE-CLICK event of the combo, I open this form, in dialog mode, let the user add the required record, then - when the form is closed, the code requeries the combo box to include the newest record... me.cboYourBox. requery

Scott C
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37787047
fwiw - you can refer to this link
Use NotInList Event to Add a Record to Combo Box
http://support.microsoft.com/?kbid=197526
0
 

Accepted Solution

by:
topUKlawyer earned 0 total points
ID: 37790591
perhaps my question was not posted as accurately as you would wish
I dont know.

I have sorted it out anyway,

in the text box there is a lookup field.

The adjacent combo also picks up that field  when changed but only when the form is closed and reopened.
i wanted to reflect that change as soon as it happened.

putting a combo box requery in the after update event of the text box only worked when the form was closed and opened again-not what i needed.

however it did work when i put me. refresh in the text box after update event just before
the combo requery.
this alerted the requery to the fact that the text box contents had changed
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37791138
upload a copy of the db
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37838454
mind posting the solution..
0
 

Author Closing Comment

by:topUKlawyer
ID: 37854949
stumblred on solution by chance
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question