Re: Validation Rule

Goto the Properties Box for your combobox, click on the Events tab, then goto
the On Not In List property. Double-click to the right of the box and click
on Code Builder. This will take you to the combobox's NotInList sub. Place
the code here for a message box to pop up giving the Alert information you
mentioned. Anytime a user enters a name not in the source for you combobox
(not in the Customers table) this code will display the messagebox.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200703/1

.

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: 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)
  • Re: ComboBox.
    ... What I am try to achieve is to use the combobox for data entry if the ... will be able to choose in the combobox the available vehicles. ... A Next and Prev commandbutton are on this form. ... If you click on the next button, it will goto to the next record but no ...
    (microsoft.public.fox.programmer.exchange)