Results 1 to 2 of 2
  1. #1
    simba is offline Advanced Beginner
    Windows 7 Access 2003
    Join Date
    Mar 2010
    Posts
    34

    cannot pull the correct record


    Hi!

    I want to run a report.

    I have to put in the patient no. in the form and when I click the "cmdParentInitialLetter" it is supposed to pull the report based on the patient number given. Rather it is asking again to put the patient number and the report runs.

    Can anyone, let me know, where am I going wrong? I have attached the code also.

    Thanks for your time.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    this happens for any number of reasons. it usually means the report can't find the field that's referenced in the popup. check the report for invalid controls, check the source. the problem can also be in the code behind the form. the popup is in error with one or the other objects.

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

Similar Threads

  1. Table relationships correct?
    By monkeyhead in forum Database Design
    Replies: 2
    Last Post: 12-07-2010, 02:22 PM
  2. Subsets (not sure if that is the correct phrase)
    By LifeIsBeautiful in forum Queries
    Replies: 1
    Last Post: 10-07-2010, 11:16 PM
  3. Code to pull in data from a specific record
    By jdunn36 in forum Access
    Replies: 1
    Last Post: 09-20-2010, 11:54 AM
  4. What is the correct syntax for
    By giladweil in forum Access
    Replies: 1
    Last Post: 07-29-2010, 04:56 AM
  5. Opening form to correct record. Bookmark?
    By stephenaa5 in forum Forms
    Replies: 11
    Last Post: 12-29-2009, 02:43 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