Hi, i am trying to get a latest salary figure to be shown in a text field on a parent form, sourced from a sub form.

But with the criteria that it is only for that employee number and that a checkbox indicating that it is the lastest salary has been checked. Here is the VB code I have used

Salary = DLookup("[AnnualNetSalary]", "TalbotTestRole ", "[Employee Number]" = Forms!TalbotTes tFormPersonalRe cords!TalbotTes tSubform![Employee...