Using Dlookup problem

[Lupson2011]

Hi, I am trying to get the latest salary figure (AnnualNetSalary), which is specific to a record (Employee Number), where a check box (LatestSalary) has been checked.



Salary = DLookup("[AnnualNetSalary]", "TalbotTestRole", "[Employee Number]" And "LatestSalary = " & True)

I thought this would work, but doesnt seem it..

Any help?

Marc

[hertfordkc]

Hi, I am trying to get the latest salary figure (AnnualNetSalary), which is specific to a record (Employee Number), where a check box (LatestSalary) has been checked.

Salary = DLookup("[AnnualNetSalary]", "TalbotTestRole", "[Employee Number]=????" And "[LatestSalary] = " & True)

I thought this would work, but doesnt seem it..

Any help?

Marc

Also,
http://office.microsoft.com/en-us/ac...001228825.aspx

MS example shows quotes around the entire 'criteria'. As you've set it up, that isn't satisfied. You might set the criteria in a string variable and then put quotes around that string variable to insure that the syntax is satisfied and the criteria is what you expect it to be.

[Lupson2011]

hi

I tried this instead
Salary = DLookup("[AnnualNetSalary]", "TalbotTestRole", "[Employee Number]= forms!TalbotTestFormPersonalRecords![Employee Number]" And "[LatestSalary] = " & True)

I thought this was bascially saying pull the latest salary figure through from this form, particular to this record where the latest salary check box was ticked.

Came back with Run Tim Error 13 'Type Mismatch Error'

Any other help?

[hertfordkc]

by MS example. Did you look at the link? I'm not on my Access box, so I'm not going to try to get the quotes corrected. Again, I suggest that you construct the criteria prior to the statement in question and temporarily use debug.print or msgbox to display the string for your verification. Put the string variable in the function and surround it with quotes.

[orange]

Try this

Salary = DLookup("[AnnualNetSalary]", "TalbotTestRole", "[Employee Number]= " & forms!TalbotTestFormPersonalRecords![Employee Number] & " And [LatestSalary] = " & True)

[Lupson2011]

Thanks both for yor help, I actually cracked it just as you posted your reply Orange. But thanks anyway

Marc

Salary = DLookup("[AnnualNetSalary]", "TalbotTestRole", "[Employee Number]=forms!TalbotTestFormPersonalRecords![Employee Number]" & " AND [LatestSalary] =" & True)