This is my first new thread. I'm a newbie trying to design a production database at a manufacturing facility. MS Access 2007. Here is question:
In my Form "DAILY PRODUCTION" the operator selects a PART NUMBER from a combo box. This combo box's source is a Table named "PART NUMBERS & CYCLE TIMES" that lists every PART NUMBER and its corresponding CYCLE TIME.
I want add a text box and use the DLookup function, such that when the operator picks the PART NUMBER, the CYCLE TIME will automatically appear in that text box for that PART NUMBER.
I can't get it to work, because I cannot get the syntax correct. Can anyone help me by typing out the correct syntax? Thank you for the help!
Also, if the DLookup function is not the best solution, please let me know. THX