Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005

    Unanswered: Disable Auto Write

    Hi, i'm using continuous form to view and write my records and whenever i finished entering my first row of record it automatically writes to the db. How do i disable it? I'm currently using a query to write to the db whenever i click on a button and i would like to disable this auto feature.


  2. #2
    Join Date
    Nov 2004
    That's standard Access behaviour. If you wish something else, you could for instance unbind the form (or go VB/VB.Net ...), and do it all by code - but I don't think that'll work with continuous forms.

    Another way, keep the continuous form locked for editing, and aling textboxes at the top fo the continuous form (header section, or in the main form), which you use for you adding/editing. Populate those controls by opening a recordset based on the primary key of a record you've doubleclicked on, selection in a combo ...

    Else, you could just accept Access for the tool it, which is quite capable of doing inserts, edits ... by itself, where you can for instance use the before update event of the form to cancel save operations, if/when that's needed.

Posting Permissions

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