![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]()
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. |
#3
|
|||
|
|||
![]()
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. . |
#4
|
|||
|
|||
![]()
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. |
#5
|
|||
|
|||
![]()
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/For...forms/201006/1 |
#6
|
|||
|
|||
![]()
This is not exactly what you were asking about, but here is a way to add a
new item to the list using the Not In List event (the combo box Limit to List property is set to Yes): http://www.mvps.org/access/forms/frm0015.htm JB10 wrote: 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? 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 [quoted text clipped - 6 lines] contact does not show up in the original job form unless I close out of that and reopen it. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201006/1 |
Thread Tools | |
Display Modes | |
|
|