Not In List

[Guest]

I have a Form called Assets, on this form I have a field called LOSS PAYEE
ID, this is an actual field name on my table called Assets which the form is
created from. The field looks the LOSSNAME from my LOSSPAYEE table to give
me a list of names on my form. My LOSSPAYEE table also has fields called
address, phone, fax postal code & contract/loan #. While I am in my Assets
form I would like to be able to type in a new LOSSNAME and have a seperate
form pop up so I can enter the phone, address, etc info for the new name I
just entered. Can anyone help me with this?

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "NotInList.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thanks a bunch, got it working

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "NotInList.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L