Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    26

    Unanswered: Multiselect Listbox with 2 functions

    I have a multiselect listbox in which users can select records for a report. I would also like to make it so that they can double click on a company name to open a window with more information about the company. However, i cannot get it to work as I would like. Is there a way to find out what was double clicked so that I can pass that to the new form that opens?
    Life's a bowl of punch, go ahead and spike it.

  2. #2
    Join Date
    May 2003
    Posts
    144
    Hope this helps.


    Dim ListRecord As Variant
    Dim strRecords As String

    For Each ListRecord In yourlistbox.ItemsSelected
    strRecords = "companyid= " & yourlistbox.ItemData(ListRecord)
    Next ListRecord

    DoCmd.OpenForm "form1", acNormal, , strRecords


    SHK

Posting Permissions

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