Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2009
    Posts
    5

    Unanswered: stop report from inserting record- access

    My form creates a report. How do I stop the from from insertng a row in the table contianing the form input data?
    EX: INput loan amount, begin date , end date. This information gets input to a row on the table.

  2. #2
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    Is your table the Recordsource for the form with the fields bound on the form?

    You should use and unbound form.

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    And if it needs to be bound, set the Data Entry and Allow Additions properties of the form to No.
    Paul

  4. #4
    Join Date
    Jan 2009
    Posts
    5
    Quote Originally Posted by pbaldy
    And if it needs to be bound, set the Data Entry and Allow Additions properties of the form to No.
    When I tried this I could no longer enter data.

  5. #5
    Join Date
    May 2005
    Posts
    1,191
    Quote Originally Posted by denise09
    My form creates a report.
    I think you may need to clarify this a little more for us to get to the bottom of this.
    Me.Geek = True

  6. #6
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Yes, as this

    Quote Originally Posted by denise09
    When I tried this I could no longer enter data
    seems to conflict with

    Quote Originally Posted by denise09
    How do I stop the from from insertng a row in the table
    Paul

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Not to mention the five other conflictive statements in post 1 and 4.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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