Results 1 to 4 of 4
  1. #1
    aljedaibi is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    2

    Employee Details by Employee ID

    Hi there! Hope this message finds u all well.




    I need to create an access form from Employee table. that will allow user to enter Employee ID then by pressing enter key, will display
    Employee Details like (Employee Name, position, department etc...) in the same form if possible.

    -desktop access database-

    -Using access 2016.-


    I really appreciat it..

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In aldetail form,that shows all records,<br>
    put an unbound text box to enter the ID,<br>
    in the AFTER UPDATE event, filter that record:<br>
    <br>
    me.filter = "[ID]=" &amp; txtID <br>
    me.filterOn = true<br>
    <br>
    If the ID is a string:<br>
    me.filter = "[ID]='" &amp; txtID &amp; "'"

  3. #3
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    Here is an example of how to do it using a Combobox in the Header of the Form
    Attached Files Attached Files

  4. #4
    aljedaibi is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    2
    Great ...... Thanks a lot to u all...it works..

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-12-2019, 12:39 PM
  2. Replies: 15
    Last Post: 05-12-2017, 04:09 AM
  3. Replies: 2
    Last Post: 05-09-2017, 04:12 PM
  4. Replies: 1
    Last Post: 04-14-2014, 11:44 AM
  5. Replies: 8
    Last Post: 06-06-2012, 12:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums