Adding a new entry to a table from a form's combobox
Setting LimitToList to False won't work here. What you want to do is set
LimitToList to True, then trap the NotInList event to add the new item (a
parameter called "NewData") to the source table. For more information see
the Access help on the NotInList event. Make sure and read the Note at the
end of the help section.
Mike
Quote:
> Hello Kimberly,
> Set the Limit to List Property of your combo box to No.
> --
> Cheryl Fischer
> Law/Sys Associates
> Houston, TX
> > Hello,
> > If I have a combo box on a form and I want the user to be
> > able to type in a new entry on the combo box, and then
> > have that entry saved to the table that populates the
> > combo box, how do I do that?
> > Thank you!
> > Kim
