Adding New Values to a Combo Box

[mare]

Hello:

I've created a form for training employees, and I have a combo box for job positions (that way we won't get spelling errors). So far, I have 2 positions listed: Buyers, and Assistant Buyers. That is all that will be required for this workshop. However, there could be a strong possibility that others employees in other positions might be required to take this program.

Instead of having to go to the "Position" Table and typing in the additional positions, I would like to have it typed into the form, so that when you are entering information on a new employee taking this program, you can either click on the "Position" Combo box and select what is already there, or you can type in a new position, such as Financial Analyst, and to have this new postion saved on to the "Position" Table.

The Position Combo box is Bound, and in Properties, I have "LimitToList" set at NO.

Any help would be appreciated.

Thank you.

 

[pbaldy]

Search here on "limittolist", the event most of us use to do that type of thing. Note you will need to change that setting.

 

[mare]

Hi pbaldy:

I don't quite understand what you mean by changing the setting. Do you mean change "limittolist" from No to Yes? I tried that and nothing happens. Is there an Event Procedure I need to enter?

P.S.: I kind of new to Access and am using 2003

 

[pbaldy]

Yes; you would enter code in the limit to list event of the combo, but that code only fires if the limit to list property is Yes. Searching on limittolist should turn up the code.

 

[mare]

Hello pbaldy:

Can you tell me what the code would be? This has become more involved than I thought.

Teach me once and I'll always remember!

 

[pbaldy]

The search I recommended turns up these among many others:

http://www.access-programmers.co.uk/forums/showthread.php?t=175797

http://www.mvps.org/access/forms/frm0015.htm