Results 1 to 3 of 3
  1. #1
    Dave14867's Avatar
    Dave14867 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Upstate NY
    Posts
    376

    Need to Have btn Click Event go to specific record

    Hello all,

    I have placed a button on a form to find an Employee Record. I have also created a query and in the criteria I have [Enter Emp Name]. What I want is that when the user types in the name and hits "OK", it will go to the Employees record. I don't know how to code it in VBA.



    I want it to run the query and go to that record

  2. #2
    Dave14867's Avatar
    Dave14867 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Upstate NY
    Posts
    376
    Found a solution, Thanks

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Quote Originally Posted by Dave14867 View Post
    Found a solution, Thanks
    So why not post it, for the benefit of others, who might want to do the same thing?
    These forums are here to help after all?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 3
    Last Post: 10-07-2020, 06:14 AM
  2. Replies: 3
    Last Post: 09-21-2019, 05:16 PM
  3. Replies: 2
    Last Post: 06-10-2019, 02:25 PM
  4. Replies: 5
    Last Post: 08-06-2018, 05:31 PM
  5. Replies: 6
    Last Post: 02-28-2017, 09:33 AM

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