Microsoft Expert 10 Time Line 11:02. When setting up the "Reps Phone" using a DLook Function I keep getting an error in the Phone Number box #ERROR Before I click on the Box or the label it blinks rapidly. I have re-watched the entire Video several times. I am unable to get it to work, I loaded up the database 10 from the library and it runs ok. What might be wrong. Here is the info on the SalesRepCombo combo box and the Reps Phone Text Box.
Combo Box Name: SalesRepCombo
Control Source: SalesRepID
RowSource:SELECT [EmployeeT].[EmpolyeeID], [EmployeeT].[FirstName], [EmployeeT].[LastName] FROM EmployeeT ORDER BY [FirstName], [LastName];
Default Vaule: =Forms![CustomerF]![SalesRepCombo]
SalesRepPhone: Text Box
ControlSource: =DLookUp("WorkPhone","EmployeeT","EmployeeID=" & [SalesRepCombo])