I used the wizard to create a lookup and all is fine. I want to go a
step further. I want to lookup a field from a foreign table which in
turn places a corresponding value in a 2nd field in the table. Can
this be done?

John King
208-424-8370
Boise, Idaho

JkingSJR wrote:

Something like this. You can out use Dlookup() perhaps in the
AfterUpdate event of a field when you want to update the value. Ex:
Me.YourFieldName = Dlookup("TableFieldName","TableName","CustID = 1")

In the above example, CustID = 1 is the where clause without the word
"Where". Check out online help.