Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    40

    Unanswered: Restricting the ability to add records

    I have a form That has 6 records on it. Each record has a Area Title (which is the primary key) and a Weight for each area. The user is not able to change the area's title, so I have locked that text box. However, they are able to change the weight of each area.
    The problem is that I don't want them to be able to add Areas either, but they can add a record by typing in a weight which of course, gives them immediate Primary Key errors because the primary key field (the title) is locked.
    SO.......how do I prevent the form from letting them add a record?

    Thanks in advance for any help you can give me.

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    Go to your form design, Press F4 to bring up the properties window of the form, in the data tab, there is a line for Allow Additions. Set it to No.
    All code ADO/ADOX unless otherwise specified.
    Mike.

  3. #3
    Join Date
    Nov 2003
    Posts
    40
    THANKS!

Posting Permissions

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