Not In List Query

[Derrick T. Davidson]

I have a form [frmTransactionBreakdown] which has a txt box that uses a query [qlkpItem] as a look up.


1. When I type in an entry that is not in the list I want a Yes No message box to pop up
2. I want the message box to ask if I want to add the Item
3. If Yes then I want the entry to be deleted and open a form [frmItem] where the item and category can be added

I can then re-open the [frmTransactionBreakdown] and the item will be added through the query.

Can anyone show me the code for the first part i.e. delete the entry and open the form

[ssanfu]

See Rogers Access Library:
http://www.rogersaccesslibrary.com/forum/topic311.html


or

http://www.dataschenk.com/DS-00016-L...t-Code-Sample/
http://www.everythingaccess.com/tuto...-lookup-tables