Sorry, is my fault,

I just copied the lines without reading. should be like this :

if Me.TxBName<"" And Me.TxBAddress<"" And Me.TxBCity<"" The
Activeworkbook.Sav

--
Message posted from http://www.ExcelForum.com