Re: add new item to combobox



Actually, LimitToList must be set to Yes to get the NotInList event to
fire...

"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:38018127-3E75-4CEB-95C1-B61CAF899DBE@xxxxxxxxxxxxxxxx
> First you need to set the Limit To List property of the combo box to No.
> Then, it the Not In List Event, you need to do whatever you want to manage
> adding the new value to the list. How you do that depends on the Row
Source
> Type property. And last, you will need to requery the combo box so the
new
> value will show up in the list.
>
> "mcnewsxp" wrote:
>
> > is there a way for a user to add an item to a combo box?
> > lets say a user doesn't find what he is looking for in the combobox and
> > wants to add new item directly to the combobox.
> > can this be doen?
> >
> > i know how to get new items into a combobox using other controls - that
is
> > not what i am asking.
> >
> > thanks,
> > mcnewsxp
> >
> >
> >


.



Relevant Pages

  • Re: Combo Box Problem
    ... You have code in the NotInList event of ... the ComboBox. ... Remove the code for the standard message or replace it with ... I have tried Limit to list property to "yes" but when you try to add data to ...
    (microsoft.public.access.forms)
  • Re: Validation Rule More Advise Please.
    ... As long as there are less than 65,000 jobs in the table, you can use a combobox ... In Form Design view, show the Toolbox ... >>Set the Limit To List property to Yes to only allow valid ...
    (microsoft.public.access.queries)
  • Re: Canceling the OnKeyDown event
    ... I have written an event handler to control the ... This same ComboBox ... disallow the update in the NotInList event, the AfterUpdate event won't ...
    (microsoft.public.access.formscoding)
  • Re: Canceling the OnKeyDown event
    ... I have written an event handler to control the ... This same ComboBox ... disallow the update in the NotInList event, the AfterUpdate event won't ...
    (microsoft.public.access.forms)
  • How to defer NotInList handling until record is saved
    ... I have a combobox that allows users to select data from a lookup table. ... NotInList event fires so I can provide code to add the new data to the ... subsequent fields to properly add the data to the lookup tables. ...
    (microsoft.public.access.formscoding)