Reply to Message

RE: Automatically fill in Access text boxes based on a combo box selection
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
Posted by smith@...
20th May 2009