Results 1 to 5 of 5
  1. #1
    hinchi1 is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2017
    Posts
    181

    Open form to specific records


    I want to be able to view keys issued to an individual when i am viewing their record. I have a table which logs keys that have been issued but i want to be able to click on a command button and view keys issued for that individual. all suggestions welcome. I have attached a form to give you some idea of what i am after an i hope this makes sense and thank you.Click image for larger version. 

Name:	Personnel blank.png 
Views:	20 
Size:	36.8 KB 
ID:	41508

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    docmd.openform "frmMyForm",,,"[key]=" & txtBoxKey

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Several way to do it.

    You could create a form bound to a query which uses the table which logs keys that have been issued. Use the Docmd.OpenForm command, with criteria, to open the form with the required records.

    You could create a form
    bound to a query which uses the table which logs keys that have been issued and put a reference in the criteria of the query to the relevant control in the form show in your post (PersonnelID).
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  4. #4
    hinchi1 is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2017
    Posts
    181
    Hi both
    Thanks for the suggestions which I have now implemented. Created new form based on query. Now just need to tidy up the form. Thanks again

  5. #5
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    As you have a one to many relationship you could add a subform to show the phone records. Lack of screen space might necessitate creating a new blank form and then using a Tab control to display each of your forms. Just another option 😉

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

Similar Threads

  1. Msg Box In Report to open a specific form
    By Derrick T. Davidson in forum Programming
    Replies: 6
    Last Post: 01-25-2016, 06:07 AM
  2. Open Form To Specific Tab
    By shoelesscraig in forum Modules
    Replies: 4
    Last Post: 12-22-2015, 01:56 PM
  3. Open form to specific record
    By zoro.1983 in forum Access
    Replies: 3
    Last Post: 05-31-2015, 11:04 AM
  4. Replies: 5
    Last Post: 08-06-2014, 02:39 PM
  5. Open to specific form
    By ecpike in forum Forms
    Replies: 2
    Last Post: 06-12-2009, 08:32 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