Limit to list Property



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

.



Relevant Pages

  • 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: Adding the same content to multiple combo boxes
    ... Load up combobox 1, and then set the List property of each of the ... Microsoft MVP - Excel ... What i have been trying to do is have> code in the UserForm_Initializesub that adds items to> the combo boxes. ...
    (microsoft.public.excel.programming)
  • Re: Validation Rule
    ... Goto the Properties Box for your combobox, click on the Events tab, then goto ... the On Not In List property. ...
    (microsoft.public.access.forms)
  • Re: add new item to combobox
    ... LimitToList must be set to Yes to get the NotInList event to ... fire... ... > First you need to set the Limit To List property of the combo box to No. ... >> wants to add new item directly to the combobox. ...
    (microsoft.public.access.formscoding)
  • 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)