N newstrom New member Local time Today, 03:07 Joined Oct 13, 2004 Messages 9 Oct 13, 2004 #1 I have the form and look up table set and working. What I would like to do is when I enter new data in the form field and it is not on the lookup table I want it to automatically add it to the table. It this doable?
I have the form and look up table set and working. What I would like to do is when I enter new data in the form field and it is not on the lookup table I want it to automatically add it to the table. It this doable?
P Pat Hartman Super Moderator Staff member Local time Today, 05:07 Joined Feb 19, 2002 Messages 47,594 Oct 14, 2004 #2 Yes. Search for posts on the Not In List Event. There are also samples in help.