I have seen numerous answers tot his question, but each time they suggest combo boxes. I cannot use a combo box because there are too many from which to select, so let's try again. I need to be able to manually enter drawing numbers and have the description of that drawing along with other data automatically fill in. The data must go into the table as a new record, not just display it. I have a master table with all the information in it. Can't I somehow enter the dwg number and upon tabbing from that box have the description and other fields auto fill? Thanks.