Results 1 to 2 of 2

Thread: Stuck

  1. #1
    Join Date
    Jan 2010
    Posts
    4

    Unanswered: Stuck

    I have a form (ErrorLog) and a table ErrorRecords. On the form I have a textbox where the user enters an EmployeeID and then I have another textbox (AssignedTo) that has Dlookup in the Control Source and will lookup the name based on the employeeid entered by the user. Right now the data is not populating to the ErrorRecords table. Is there a way to have that data populate to the table. This is the formula I currently have in the AssignedTo textbox Control Source: =DLookUp("FirstName & ' ' & LastName","Employees","EmployeeID = " & Forms!ErrorLog!EmployeeID). Do I need to do something else?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Move your DLookup() to the EmployeeID_AfterUpdate event and then in AssignedTo ControlSource place the field in the table you want it stored in.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •