Beacon, thanks for you reply!
I have a form that contains several different text boxes: PartID, PartNo, Drawing Reference, Description and Material. I also have one search box that auto-fills the appropriate text boxes with their respective data when a part # is entered in the search box. Now, I only want a search box that can look up the drawing reference
that will also fill the appropriate text boxes with their respective data. I hope I make sense. I didn't create this DB but I am the one who makes modifications if there is a problem. Please let me know what I can do to make this happen.
I appreciate your help, Beacon, very much!