Results 1 to 7 of 7
  1. #1
    mlrucci is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2018
    Posts
    202

    troubles with open new form with same ID

    Good morning, I am frustrated. I have a form "frmLogProcedure" that has a field [MRNID] named "txtMRNID". I want open a second form "frmMRNUpdate" with same ID. I used the code DoCmd.OpenForm "frmMRNUpdate",,,"[MRNID] =" & Me.txtMRNID. I have checked all the different fields for accurate spelling/names. When button clicked, frmMRNUpdate opens, but the ID will not flow over.



    Form Field Field Name
    frmLogProcedure MRNID txtMRNID
    frmMRNUpdate MRNID txtMRNID

    I tried to even thought the button may be corrupt and created a new one. Any insight?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    That code would (should) open the second form filtered to existing records with that ID. Are you trying to add a new record on the second form?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    mlrucci is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2018
    Posts
    202
    No, the ID already exists. Just trying to open the form with the same ID so that they could update the client information.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Make sure the data entry property of frmMRNUpdate is not set to Yes. If that isn't it, can you attach the db here?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Had to edit the above if you've already seen it, somehow "not" got missed.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    mlrucci is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2018
    Posts
    202
    That was it!!!! Thank you very much. Has been driving me crazy for hours. couldn't figure it out.

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Newbie Troubles
    By Deciel in forum Programming
    Replies: 1
    Last Post: 02-05-2014, 03:45 AM
  2. SQL Troubles
    By dccjr in forum Programming
    Replies: 5
    Last Post: 10-10-2013, 07:58 PM
  3. Subquery Troubles
    By glennib in forum Queries
    Replies: 1
    Last Post: 07-11-2013, 01:08 PM
  4. Query troubles.
    By SteveSummers in forum Access
    Replies: 1
    Last Post: 10-26-2011, 07:48 PM
  5. Form calculating troubles
    By Ufalufa in forum Access
    Replies: 0
    Last Post: 11-27-2007, 10:36 PM

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