I have a control on a subform whose control source is:
DLookup("[FullName]","tblUserInfo","[EmployeeID] = " & Me.PreviousOwner)
PreviousOwner is a longInteger and EmployeeID is an autoNumber. On another form when ownership of equipment changes hands, I simply pick another user from a drop down list and select the previous owner from another drop down list.
When I open the form and subform I get #Name?. Where am I going wrong?
DLookup("[FullName]","tblUserInfo","[EmployeeID] = " & Me.PreviousOwner)
PreviousOwner is a longInteger and EmployeeID is an autoNumber. On another form when ownership of equipment changes hands, I simply pick another user from a drop down list and select the previous owner from another drop down list.
When I open the form and subform I get #Name?. Where am I going wrong?