I have a Entry Form, and in this form we need to enter the Part #, and then the field below should populate with the correct description of that part number from the table it is in. The correct description is not coming up correctly when I hit enter. I believe it is just going to the next record instead of choosing the correct description. How can I make this populate correctly?
Part# Part Description Quantity 1 A/C ACCUMULATOR