That's one of my favorite tricks on forms that only need a few fields updated from a combo. It takes a lot less code than looping throug a recordset for each text box or using a dlookup for each.

I think it's also faster than the above mentioned methods, although I may be fancying that since I think this trick is clever

Thanks for the post.
Lisa