NotinList - Insert into help

[Muna]

The row source for the combo-box is

SELECT tbl_p.P_ID, [plast] & " , " & [pFirst] AS Expr1 FROM tbl_p ORDER BY [plast] & " , " & [pFirst];

If notinlist I would like to add the the new name, how should I write the INSERT Statement?


Thanks,

 

[vbaInet]

How about using the Allow Value List Edits and List Items Edit Form properties?