Re: Combo Box Problem

That message is coming from *YOU*. You have code in the NotInList event of
the ComboBox. Remove the code for the standard message or replace it with
one of your own.

maxjake wrote:
Hi All

I have a combo box with is linked to a column in a table. This column
can only have the values that are already listed in the combo box. How
do I prevent the user from entered any other values then what is
listing in the combo box?

I have tried Limit to list property to "yes" but when you try to add data to
the field the message is:-
Double - Click this field to add entry to the list.

Can I stop this?

Thanks Max

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

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

.

Relevant Pages

  • 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: 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: query then modify table from form
    ... When you attempted to use the NotInList event, did you also set the Limit To ... List property to Yes? ... Dim strSql As String ... ' // Set the current ReportTo with ID ...
    (microsoft.public.access.modulesdaovba)
  • 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)