SQL Query in a Form Control

[kcddoorman]

expr1:(SELECT employees.sku from employees where employees.id = [employee];)

This is a subquery sql statement.
Can I get this to work in a text box control in a form?
Employees is a table.
Labor is a table that looks up data from the employee table with this lookup query;

SELECT employees.ID, employees.name, employees.sku, employees.initials FROM employees; 

The Labor table is being shown in a subform that is filtered by a job number.
I want to show the employees.sku in the subform so it is printed with the rest of the form. I created a text box control that get the time difference from the labor.work_in_time and labor.work_out_time like this;

=(DateDiff("n",[work_in_time],[work_out_time])\60 & Format(DateDiff("n",[work_in_time],[work_out_time]) Mod 60,"\:00"))

I'm having trouble with getting a sql statement that works in a query to work in a form control. Is there some different syntax or something? Besides wrapping it in parentheses and putting an equals sign in front of it, I'm not sure what I'm missing.

[kcddoorman]

I tried making a query that gives me the needed data and using that as the record source for the sub form but a query doesn't allow you to add new records.

[kcddoorman]

DLOOKUP ! YAY

=DLookUp("sku","employees","ID = [employee]")