Consulting

Results 1 to 2 of 2

Thread: Need help with Dlookup

  1. #1
    VBAX Newbie
    Joined
    Jun 2019
    Posts
    1
    Location

    Need help with Dlookup

    I am working on a database for the company that I work for that will be used to record inspection results. In my "user form," I have a text box that I want to "lookup" the name of the job that the user is inputting results for, based on the "Job number" that the user inputs. How can I do this with dlookup? And is there a better strategy than dlookup?

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    I would use a Combo Drop down box to list the Job Numbers and Jobs in the second column, the combo jumps to the job number as the user inputs the number, or they can just select one from the list.
    You then just need some simple vba in the "After Update" event procedure of the combo box.
    me.textboxname = mecomboxname.column(1)
    Where textboxname is the actual name of your text box and mecomboxname is the name of your combo.

Tags for this Thread

Posting Permissions

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