Results 1 to 2 of 2

Thread: [RESOLVED] MsgBox Error Popup with Primary Key

  1. #1

    Thread Starter
    Member
    Join Date
    Apr 2010
    Posts
    34

    Resolved [RESOLVED] MsgBox Error Popup with Primary Key

    I've attached my database in Access 2007. I am getting a MsgBox Popup with the docID (my primary key for my main table) in quotes. I can't figure out what I wrote in the code to cause this or if it is something more major than I can see (I'm very new to VBA). Does anyone know why this is happening and how I can make it go away???

    http://www.4shared.com/file/pGO1JNKZ...FinalDemo.html

    To see the error I am concerned with:

    Open Database link.

    From the form that pops up on opening the database (frmMainMenu), select the option "SOP Document Tracking" from the SOP Document Management option group.

    A MsgBox will Pop Up with directions to "Find document on next form and then select OK." Select "OK"

    Then a form (frmDocSearch) will Pop Up. Select any row from this form and select "OK".

    This is where my error appears. A Pop Up box with a number which corresponds to that document's docID, which is the Primary Key for tblDocumentInformation. It says "Microsoft Office Acc..." but it is not resizable so I can't see the rest of it.

    After you select "OK" it goes away and pulls up the correct form. But I'm thinking this is from one of the error handlers. I came in during the middle of this database's development and I'm not sure if it is part of the code I wrote or from my predecessor.

    Any suggestions would be greatly appreciated!!

  2. #2

    Thread Starter
    Member
    Join Date
    Apr 2010
    Posts
    34

    Re: MsgBox Error Popup with Primary Key

    Figured it out. If anyone looked at it yet, it was on my frmMasterTabForm, Case Else MsgBox frmType.

Tags for this Thread

Posting Permissions

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



Click Here to Expand Forum to Full Width