Limit to list Property

[injanib via AccessMonster.com]

is it possible that if the limit to list property of a combobox is set to
true the focus is passed onto another field? What I mean is that I have a
combo box with the limit to list property set to true. the Notinlist event
procedure prompts that the entry is not in the list and if I want to add it
to the list. This is where it becomes tricky. Some times I want to add the
new data in the list if it is a new permanent employee, which then it adds it
to the list and requeries and then I can move on to the next field. But some
times I get employees that are temporary and I do not wish to add them to the
list, however, I do need to enter that name for that record. So if I want
enter that name without having to add it to the list I get stuck at the
combobox and can't move on. If there is a way doing this without setting the
limit to list property to yes I would love to know about it. Thanks in
advance.

--
Message posted via http://www.accessmonster.com

[Larry Linson]

"injanib via AccessMonster.com" <u35551@uwewrote in message
news:7784eb427cdc0@uwe...

is it possible that if the limit to list property of a combobox is set to
true the focus is passed onto another field? What I mean is that I have a
combo box with the limit to list property set to true. the Notinlist event
procedure prompts that the entry is not in the list and if I want to add
it
to the list. This is where it becomes tricky. Some times I want to add the
new data in the list if it is a new permanent employee, which then it adds
it
to the list and requeries and then I can move on to the next field. But
some
times I get employees that are temporary and I do not wish to add them to
the
list, however, I do need to enter that name for that record. So if I want
enter that name without having to add it to the list I get stuck at the
combobox and can't move on. If there is a way doing this without setting
the
limit to list property to yes I would love to know about it. Thanks in
advance.

Is there a way to do _what_?

Clearly, "Limit to List" seems to be "working as desgined." That is, it
will not allow entering data that isn't on the list.

In answer to your question, you can do just about anything you wish in code
you write for the NotInList event.

Every combo box that I've ever created for Employees has had a Row Source
that stored the Employee ID, displayed the Employee Name, based on an
Employees Table. Perhaps there are occasions when it would be appropriate
to have a NotInList event that allowed adding an Employee, but generally, in
the applications on which I've worked, there was a company procedure to be
followed, and not just any user could "add a new employee."

Larry Linson
Microsoft Access MVP