Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2014
    Posts
    1

    Red face Unanswered: Cannot add record

    I have returned to a Access 2003 database after many years of not using it, and am a complete Access novice.

    The database form I use to enter data works from one main table, and two other simple tables.

    When I click on new record, it will not allow me to enter any data in the blank fields and just beeps at me.

    I have look at the form properties, and Allow Edits, Deletions and Additions are all set as Yes.

    There are no queries used on the form, just tables.

    Any thoughts?

    Mike

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by mkjsmith View Post

    ...The database form...works from one main table, and two other simple tables...

    ...There are no queries used on the form, just tables....
    Sorry, but the above statements are mutually exclusive! If the fields on your form come from multiple tables it is based on a query! You may not have sat down and designed a query, but one of the Access Wizards has done this, using the fields you've selected from the multiple tables. If you go to the Data Tab on the Properties Pane, for the Form, and look at the RecordSource, you should see a SQL Statement for the Query. Most multi-table queries are Read-Only, as yours apparently is.

    Are your tables in a one-to-many relationship? The usual workaround is to use a main form for your one side of the relationship and a subform for each of the many-side tables, joined by a common field that is the Primary Key in the main table and a Foreign Key in the many-side tables.

    Linq ;0)>
    Last edited by Missinglinq; 04-06-14 at 15:07.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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