Results 1 to 3 of 3
  1. #1
    kiamba is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2022
    Posts
    14

    List box help with coding to open a line

    HI, i am have this job list on the side of a database i am trying to get working.



    I need to workout how to click on one of the jobs there and have it open for me.

    any help appreciated
    Attached Thumbnails Attached Thumbnails 123.PNG  

  2. #2
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,372
    If this is a listbox on a form, you'd use the click or double click event of the listbox to open a form to the record you wish to display. If you're coding, the click even is listed on the Event tab of the property sheet (when the listbox is the selected control in design view). The ellipses button on the line for the even will open the code window. Personally I'd use the double click event, not the click event.

    Not hard to do what you need, but it seems that you don't have the basics yet, so try this site or find one you like better.
    https://social.msdn.microsoft.com/Fo...orum=accessdev
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    kiamba is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2022
    Posts
    14
    thank you, yes i thought it would be easy, but i am a total newby , but everyday i learn a bit more

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

Similar Threads

  1. Line Break In My Forms List Box
    By BakerMan in forum Forms
    Replies: 6
    Last Post: 05-20-2019, 07:27 AM
  2. Error coding for AVDoc.Open()
    By TerraEarth in forum Programming
    Replies: 5
    Last Post: 06-05-2018, 07:16 PM
  3. Replies: 10
    Last Post: 08-21-2015, 12:12 PM
  4. Replies: 1
    Last Post: 03-17-2015, 01:06 PM
  5. Color Coding on an Unbound List Box
    By JustTrying in forum Forms
    Replies: 2
    Last Post: 12-24-2014, 08:21 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