Subform datasheet view use Dlookup information from another table

Occasional Visitor

I am using below method (Dlookup) in order to get paid amount "Accrued" to employee by using employee ID (empNo) key to call the information.

"Accrued" is the filed in subform datasheet view that I want to fill, but I am not getting the exact value.

  • VacBalCalu : is subform datasheet view
  • temp_CurrentVacDate : is textbox containing table name (domain)
  • Accrued : is a filed in subform datasheet

Forms![VacBalCalu]![Accrued].Value = DLookup("Accrued", "" & [temp_CurrentVacDate] & "", "EmpNo = '" & [EmpNo] & "'")issue2.PNG

0 Replies