View Single Post
  #3  
Old June 2nd, 2010, 05:54 PM posted to microsoft.public.access.forms
tighe
external usenet poster
 
Posts: 53
Default Combo Box Adding Button to edit list items

i believe it best to requery the combo box on the close event of the form
the user adds the contact to.

Sub Form_Close()
Forms![Form_name]![Combo1].Requery
End Sub

"JB10" wrote:

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.

.