Dlookup syntax

[crowegreg]

I can't figure out what my syntax should be.

Me.MidSalaryRange = DLookup("[Midpoint]", "FTE_Salary_Ranges", "[Schedule] = " & "'" & strLookup & "'" And "[Grade] = " & "'" & Me.JobSalaryGrade & "'")

Both fields schedule and grade exist within table "FTE_Salary_Ranges"




Thank you in advance!!

[NTC]

this is always tricky and the correct syntax depends on the content whether it be a number or text

definitely your first & is not correct

strLookUp needs to be dimensioned/defined - possibly you just didn't show that...not sure

chop it in half and drop the AND portion in order to do things in steps

there is actually a lot of examples out there in Bing/Google on this topic....search on the WHERE clause syntax

[crowegreg]

Thanks for the quick update.

In the code not displayed, strLookup is dimensioned.

Here's what I got to work:

Me.MidSalaryRange = DLookup("[Midpoint]", "FTE_Salary_Ranges", "[Schedule] = '" & strLookup & "' And [Grade] = '" & Me.JobSalaryGrade & "'")