Just like a lot of others, i have a combo box that works perfect for what i'm doing. I now would like to add an expression to put in a value lookup from a table. Table is called "Master Parts" the parts consist of both numbers and letters.
then i've placed an unbound text box and would like to have it put in a value from another table.
Combo box puts in the value from a bound box. How do i get the value from the combo box to my unbound text box?
I've read a few posts on here, and followed "application.dlookup method [access]
This is what i've tried. I didn't add anything in for criteria....yet, as i don't think it's needed?
DLookUp(«expression», «domain», «criteria»)
=DLookUp([Combo414].[column](7),[Master Parts]![Location])
Master Parts is my table where all the part numbers are kept in one column, and location is in another column, same table.
I do know i've done something in correct here, and hoping some nice individual would help.
Tks in advance. Eric..