[AccessD] NotInList Problem

On 22 Apr 2003 at 18:33, David & Joanne Gould wrote:

> I am trying to add a new record into a table when the user types an
> entry into a combo box that triggers the NotInList event. My problem
> is trying to use the text that was typed in. How do I find it
> prgramatically?
> 
> The table only has two fields: Autonumber (PK) and a descriptive text
> field.
> 

Look at the NotInList Event:

Private Sub Combo0_NotInList(NewData As String, Response As Integer)

NewData contains the newly entered string.
Response is a flag which defines how the event is handled after your 
code has been executed in the Sub.

Just insert  NewData  into the table and set Response to 
acDataErrAdded








-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.