Results 1 to 3 of 3
  1. #1
    Zipster1967 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    May 2006
    Location
    Wisconsin
    Posts
    19

    Event trigger when a record in a subform is selected

    I have a subform that has a recordset that I want another form to open when a record is selected from the subform. What event do I use and in what form to I add the VBA code to for this situation?
    The main form that I am selecting records through is my search form called frmInventorySrch. When entries are made in this form certain records are displayed in the subform frmInventory What I want is to be able to bring up another form called frmLayout that uses box controls to represent different areas of the shop where the item can be located and change the color of the box that corresponds to the location of the item in question. My question is what event do I use and in what form do I trigger the event?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    I do this with the DblClick event of the subform. User double clicks the Record Selector at left edge of form. Code would be like:
    DoCmd.OpenForm "formname", , , criteria here
    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
    Zipster1967 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    May 2006
    Location
    Wisconsin
    Posts
    19
    I can see that as being a possibility but you can highlight each record in the subform So you should be able to trigger an event for the highlighted record. That is really what I am looking for.

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

Similar Threads

  1. Replies: 5
    Last Post: 05-11-2011, 07:32 PM
  2. Replies: 4
    Last Post: 04-07-2011, 04:38 PM
  3. Replies: 1
    Last Post: 10-13-2010, 12:40 PM
  4. Trigger subform event
    By tuna in forum Forms
    Replies: 0
    Last Post: 05-09-2010, 06:29 AM
  5. Replies: 0
    Last Post: 03-11-2010, 02:11 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