DLookup()

[Wantula]

I posted something regarding lookup values(22/11/2004).A solution was
suggested which requires me to use the DLookup() which I have read and
understood, but the probem is, where exactly do I type these DLookup
commands, is it on the field just next to the After Update,or in the
expression builder?
Please help,
wantula

 

[Duane Hookom]

Actually based on your earlier posting, your combo box can contain the
column with the unit price. If your combo box name is cboItem and its row
source is
SELECT Item, UnitPrice
FROM Stock
Assuming you want to "display" the UnitPrice in a text box, use a Control
Source of a text box of
=cboItem.Column(1)

BTW: please keep all questions in the same thread rather than requiring us
to search for your previous posts.