Join query using between

Question

I have made this work before, but I can not find it and do not remember how.

SELECT tblMyData.ID, tblMyData.LineNum, tblBudgetRange.[Budget Name] 
FROM tblMyData 
INNER JOIN tblBudgetRange 
ON tblMyData.LineNum Between ([tblBudgetRange].[fromLine]) And ([tblBudgetRange].[toLine]);

I also tried DLookUp("BudgetName","tblBudgetRange", [LineNum] & "Between fromLine and toLine".