Trying To Create An Automatic Payroll Form

Hello,

I am basically doing FORM to automatically figure out my stylists commission pay, based on 5 levels of sales and 3 different pay levels, that I will cut and paste in a table from my POS system.

3 Total Tables.
tbl_Employees, with the headers ID, Name, Payroll ID, Comm_Level.
tbl-Current Year with the headers ID, Payroll ID, Name, Service Sales.
tbl_Comm with the headers ID, CommLow, CommHigh, Level1, Level2, Level3

In a query, Qry_Years, I have Payroll ID, linked between the tbl_Employees and tbl-Current Year.

I am close in a FORM to getting this to work, unless DLookup is the wrong why to go about this.

This is not correct, but gives you an idea of what I am trying to do. In a FORM text box (called framePayrollIDLookup) I have
=DLookUp("Level1","tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]").
This pulls up the correct pay percent for level1 employees, but i need to change out Level1 to something variable.
This also doesn't work, but gives you an idea of my though process.
=DLookUp(" " = framePayrollIDLookup,"tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]"), but this doesn't work.

I might be way off base on how to do this, but I am trying. Thanks for any help.
Chris