Arthur Fuller
fuller.artful at gmail.com
Mon Mar 30 10:30:08 CDT 2009
You neglected to mention whether the new-to-add row should go into T1 or T2. That is important! Either way, the general approach is to supply a procedure for "NotInList" that opens a form in dialog mode, with two buttons OK and Close, the former making the form invisible and the latter closing it. Then the code in the other form asks whether the form is still open (indicating OK) and if so, grabs the value and plunks it into the list. You should also provide version number of Access and any attendant service patches. I don't mean to be pedantic but this info is important. For example, the answer is completely different if the FE is Access 2007, which resolves almost all of this automatically. Arthur