Results 1 to 4 of 4
  1. #1
    alsoto is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2009
    Posts
    67

    Anything wrong with this one line of code?

    DoCmd.OpenReport "Report1", , , "SocialSecurity = " & Me!SocialSecurity



    Report doesn't print.

    Al

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I would think the SS field woud be text so you need quotes:
    DoCmd.OpenReport "Report1", , , "[SocialSecurity]= '" & Me!SocialSecurity & "'"

  3. #3
    alsoto is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2009
    Posts
    67

    That was it

    Rg you are a rockstar!!!


    Thank you

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad I could help. Thanks for marking the thread Solved.

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

Similar Threads

  1. Line-Bar Chart Issue
    By santoshpk in forum Reports
    Replies: 0
    Last Post: 03-17-2009, 02:47 PM
  2. Design In-Line Function ???
    By caljohn527 in forum Queries
    Replies: 0
    Last Post: 01-28-2009, 03:48 PM
  3. What am I doing wrong?
    By brandon in forum Access
    Replies: 2
    Last Post: 08-03-2008, 10:26 AM
  4. Replies: 3
    Last Post: 03-24-2006, 08:40 AM
  5. line skip in bookmarks
    By emilylu3 in forum Programming
    Replies: 0
    Last Post: 03-21-2006, 02:58 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