A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combo Box Adding Button to edit list items



 
 
Thread Tools Display Modes
  #1  
Old June 2nd, 2010, 05:07 PM posted to microsoft.public.access.forms
JB10
external usenet poster
 
Posts: 2
Default Combo Box Adding Button to edit list items

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  
Old June 2nd, 2010, 05:09 PM posted to microsoft.public.access.forms
JB10
external usenet poster
 
Posts: 2
Default Combo Box Adding Button to edit list items

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

.

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



  #5  
Old June 3rd, 2010, 04:39 AM posted to microsoft.public.access.forms
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default Combo Box Adding Button to edit list items

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  
Old June 3rd, 2010, 12:10 PM posted to microsoft.public.access.forms
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Combo Box Adding Button to edit list items

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.