Consulting

Results 1 to 2 of 2

Thread: SOLVED: Disable deleting data from table

  1. #1
    VBAX Regular
    Joined
    Jun 2004
    Posts
    28
    Location

    SOLVED: Disable deleting data from table

    Dear Friends,

    I have a table called customers and created a form to enter data in the table.
    However, I want to give the user no option of deleting or overwriting existing table records. In other words I want the form always to go after the last record of the table and add new records with changing anything else in the table.

    Any ideas how to do that?

    Thanks,
    G

  2. #2
    VBAX Tutor SJ McAbney's Avatar
    Joined
    May 2004
    Location
    Glasgow
    Posts
    243
    Location
    First of all, you shouldn't bind a table to a form...ever.

    Always use a query - even if it is effectively another object that displays all the table's records. With a query you can sort the records loaded into a form.

    All you need to do to resolve your problem is find the form's DataEntry property and set this to Yes.

Posting Permissions

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