DlookUp function in Continous form

[wshm]

I have this coding for txtUnit.

Me.txtUnit = DLookup("produnitname", "tbl_DeptProGoalUpdate", "deptbudno = '" & Me![txtDeptBudNo] & "'")

because the field is not bound, every record
is showing as a same value.
a problem...
if I create a field in another table(forms rec source)
and bound this field, then i can't use the dlookup

if i use the dlookup function, the value is repeated..

how can i resolve this problem?

 

[wshm]

oops.
"because the field is not bound, every record
is showing as a same value."
forgot to mention that it's a continous form

 

[wshm]

whew nvm. i created a query to make this work.

UPDATE tbl_DeptBudget INNER JOIN tbl_estUnitCost ON tbl_deptbudget.deptbudno = tbl_estunitcost.deptbudno
SET tbl_DeptBudget.estunitcost = [tbl_estunitcost].[estunitcost];