Dlookup and combo box.

[Eric2013]

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..

[pbaldy]

You might find this easier:

BaldyWeb - Autofill

Here is the syntax of the DLookup() if you want to stay with it:

DLookup Usage Samples

You would need a criteria.

[NTC]

Q: How do i get the value from the combo box to my unbound text box?

A: in the unbound text box put as its control:
=[ComboboxName].column(CorrectNumber)

the .column is literal and you must have the parenthesis around whatever is the correct number; btw the numbering of columns begins with 0.....