I could, but that would not work with the process,

What I want is if the entry is not in the list for it to warn the data
entry person that they have to add this item into the other sheet, but
i still want them to be able to finish there current entry before going
to add the item,

eventually i want if the item is not in the list then the entry will
continue , and when it is entered with the ok button then it open up
the "FormAdAsset" and put the new serial number into the "TextSerialNo"
field so that the asset can be added

so really the msgbox warning is just a interm until i have the time to
write the code for what i really want it to do, which will just be an
extension to the warning code im after

make sense?

cheers