Using "not in list" to add data to two fields

[jlm722]

Hey there forum friends, I have a dilemma. I have a table (let’s call it tblAcctNum). It has two fields, AcctNumber and AcctName. On one of my forms, I have a combo box that looks up numbers in the “AcctNumber” field. The main reason for this is many of the “AcctNumber”s are used quite frequently. I also have a dlookup function on my form that displays the “AcctName” field that is matched to the AcctNumber. I am familiar with how to set the “not in list” event procedure to add a new AcctNumber. My dilemma is, I want the “not in list” event to open a pop-up form that will allow me to enter BOTH new fields, then click a save button that will return me back to the original form with the new information added so I may continue.

[RuralGuy]

That is what the NotInList does best! http://www.baldyweb.com/OpenArgs.htm