View Single Post
  #4  
Old June 2nd, 2010, 09:58 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Combo Box Adding Button to edit list items

Have you looked into using the NotInList event and the LimitToList property?
That would do away with having to add a button and force the user to click
anything...

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 pseudocode 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.

"JB10" u60538@uwe wrote in message news:a8ee7d696b7e8@uwe...
I have a form which is designed to enter information about jobs we have
completed. It has 3 combo boxes for different types of contacts that are
pulled from different tables. I want the user to be able to select from
the
list or add a new contact. I know they can right click on the drop down
arrow for the combo box and select "Edit List Items" but I really would
like
to add a button next to each combo box that gives them that option. I
have
tried creating a button next to it that opens up the form for the contact
and
then a button on that newly opened form to save and close. However, the
new
contact does not show up in the original job form unless I close out of
that
and reopen it.