Combo Box Adding Button to edit list items
in [Form]
|
From: JB10 on 2 Jun 2010 12:07 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.
From: JB10 on 2 Jun 2010 12:09 Also wondering if after the new list item is added, is there a way to avoid having to select it from the list. Can it automatically be selected after adding it? 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.
From: tighe on 2 Jun 2010 12:54 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. > > . >
From: Jeff Boyce on 2 Jun 2010 16:58 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(a)uwe> wrote in message news:a8ee7d696b7e8(a)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. >
From: PieterLinden via AccessMonster.com on 2 Jun 2010 23:39
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. "It has 3 combo boxes for different types of contacts that are pulled from different tables" Ouch. Not usually a good plan of attack. Can't you subclass the people if you need to? (Add some 1-1 tables). How do you figure out which table to get the contact from? Even if you are storing radically different information about each type of person, you could still use the 1-1 approach. See Rebecca Riordan's article on Access Web for details. www.mvps.org/access -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201006/1 |