Refresh data in a control

[Elizabeth]

Hi -

I have a form that uses a combo box control lookup to pull in the name of
contacts. On this form, I have a button to add a new contact if the one
wanted isn't already in the list. When the entry is done and the person
returns to the first form, the newly added contact needs to appear in the
list. I've tried requerying the control and the form from the Got Focus and
On Current events and haven't had any luck. I'm sure I'm missing something
simple, but can someone help break my block?

Thanks!

 

[Jeff Boyce]

Take a look at Access HELP re: NotInList ... HELP should have examples of
the code you'd use...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Mr. B]

Elizabeth,

Place your code to requery your combo box either in the On Close event of
the second form or in the Click event of any button that may close the second
form where the new value is being entered.

You will have to use a "full" reference the the first form and the control
to be requeried.

"Forms!FormName!ControlName.requery

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm