Results 1 to 4 of 4
  1. #1
    gostap is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    30

    Report problems again.. :(

    Desperately need help with a report!




    I have a report, “rptKorJournal” that is based on query qryKorJournal.


    There is a form, “frmPrintJournal” with a combobx to select “kund” for printing the report.
    The combobox only have to records, name of the “Kund” based of table “tblKund”
    When I select a “Kund” the report shows everything right as it should, but for some strange reason it suddenly change one of the records name (Johan Persson) to a digit?? Both in the report and in the table? However, it still works but causes lot o trouble changing name to a digit because table “tblKund” is involved with other stuff in the database. I tried hard to see what I am doing wrong, but given up now.. Someone got any idea what I am doing wrong??


    Thanks in advance

    ps. from the beginning it works, show the name as it should, but when I close the form"frmPrintJournal" the table has changed the name to a digit.



    GostapstrippedRep.zip

  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
    The form and combo are bound to the table. I'd remove the control source of the combo and the record source of the form.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    gostap is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    30
    How stupid I can be! It works, thanks a lot for your help!

    BG/Gostap

  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
    No problemo! Don't feel bad, we all have the occasional brain cramp.
    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. report problems
    By gostap in forum Reports
    Replies: 4
    Last Post: 09-19-2021, 03:25 PM
  2. Report View Problems!!!
    By nj2la96 in forum Reports
    Replies: 4
    Last Post: 02-08-2016, 04:28 PM
  3. Problems w/report
    By papabill in forum Reports
    Replies: 9
    Last Post: 04-27-2015, 12:48 PM
  4. Report problems
    By BarbT in forum Access
    Replies: 3
    Last Post: 05-09-2011, 09:33 AM
  5. Problems with Report Filter
    By eww in forum Programming
    Replies: 1
    Last Post: 10-20-2010, 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