I 'm using Access '97 and have a form that is based on a table. One of the fields is a combo box that looks up names from another table. The Look up tab for the field has the following properties:

Display Control Combo Box
Row/Type Source Table/Quary
Row Source name of table
Bound Column 1
Column Count 1
Column head 1
Column Width Blank
List Rows 8
List Width Auto
Limit to list Yes

In the form's Event-"on not in list" box I have a macro. The macro's action box I have Msgbox and the following in the Action Arguements boxes:

Message Double Click to Add New Court to List
Beep Yes
Type Information
Title Add New Court

When I enter a court name not in the table the message box does not pop up. I can get the double click event to work but not the message box. What am I doing wrong? Thanks for the help.

The use of macros is not generally recommended in access, they have no error handling capacity. Have a look at the "Solutions" database for an example of how to do this in code. Solutions should be in your samples folder if not you can download it from MS.

check out the Microsoft Knowledge base and search for thread Q161007

this is about using the NotInList event, which can easily be manipulated to produce your desired message when you require.

hope this helps