access refresh combo box

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.
topUKlawyerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
use the afterupdate event to requery the combo box..
Brian PiercePhotographerCommented:
Agreed - as the last instruction in the code add

me.ComboBoxName.requery

(where ComboBoxName is the name of your combo box)
topUKlawyerAuthor Commented:
Yes but the after event of which control ?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Rey Obrero (Capricorn1)Commented:
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" ?
clarkscottCommented:
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
Rey Obrero (Capricorn1)Commented:
fwiw - you can refer to this link
Use NotInList Event to Add a Record to Combo Box
http://support.microsoft.com/?kbid=197526
topUKlawyerAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rey Obrero (Capricorn1)Commented:
upload a copy of the db
Rey Obrero (Capricorn1)Commented:
mind posting the solution..
topUKlawyerAuthor Commented:
stumblred on solution by chance
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.