Dlookup

[Bob M]

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?

 

[Mile-O]

Try:

=DLookup("[FullName]","tblUserInfo","[EmployeeID] = " & Me.Parent.PreviousOwner)

 

[Bob M]

DLookup

PreviousOwner is not on the parent form, it's on the same form as the control.

 

[KevinM]

=DLookup("[FullName]","tblUserInfo","[EmployeeID] = " & [PreviousOwner])

 

[Bob M]

DLookup

Thanks Kevin. That worked. Keep up the good work.