Results 1 to 6 of 6
  1. #1
    kulle is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2011
    Posts
    7

    Want to be able to select and work with query results

    I have a simple form that has a listbox. The row source for that list box is a simple query that displays results in the window. I would like to be able to select any one of the results and have it open up that selected record .



    The basic makeup is a form used to enter device asset information, with 2 queries, one query displaying what devices are available and another query of what devices are out on loan. I want to be able to go directly to that record from within the query result window. Any ideas? I used to have a similar dbase, but got rid of it.

    Thanks in advance for your support

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Do you want to open another independent form or filter the recordset of form the listbox is on? The listbox is unbound?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    kulle is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2011
    Posts
    7
    Listbox is unbound and I would like to open another form that I have created which is used to input the devices. You know what I mean? Right now I am populating it so there are only like 10 records, so it's no big deal to go back to the form and cycle through until I get to the record I want, but as it grows, I believe it is a filter on what I select. So the logic is , on dbl click, goto record in form, where what I selected = that reocrd in the form.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    In AfterUpdate event of listbox, can open another form with:

    DoCmd.OpenForm "formname", , ,"ID=" & Me.ID

    Where the ID's are the pk/fk fields of the related tables.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    kulle is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2011
    Posts
    7
    So I tried that and it didn't work. It's only one table and the PK is actually "ID"

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You want two forms bound to the same data source? Can you provide project for analysis?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 6
    Last Post: 05-14-2012, 07:24 AM
  2. Multi Select Simple Returning No Results
    By jsimard in forum Programming
    Replies: 11
    Last Post: 01-24-2012, 10:28 PM
  3. Replies: 11
    Last Post: 12-14-2010, 01:25 PM
  4. Replies: 4
    Last Post: 10-12-2010, 02:11 PM
  5. Replies: 2
    Last Post: 03-31-2009, 11:15 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