NOT IN LIST EVENT

[NEOFYTOS]

USING the Combo Box's Not In List event with multiple fields:
I WANT to know how i can use this event.
i have one table (T_Teams) with the following fields:
TeamId,FirstName,LastName
and another one Table (T_RecordTeam) with the following fields
forest,comp,polygon,firstlastname(i have a concatenate query first&lastname).

my question know is how i can insert values in the firstlast name field
which are not included in the table T_Teams and at the same time the new
entry records to pass to the table T_Teams and T_RecordTeam.

 

[Allen Browne]

See:
Adding values to lookup tables
at:
http://allenbrowne.com/ser-27.html

The article gives 4 ways to do this.