Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006

    Unanswered: Query based form not allowing new additions ?

    I have a query:

    Here is the SQL code:

    SELECT tbl_element.[site id], tbl_review.[delivery], tbl_review.[inhouse], tbl_review.[review description]
    FROM tbl_element INNER JOIN tbl_review ON tbl_element.[element id] = tbl_review.[element id]
    WHERE (((tbl_element.[site id])=[Input Site Number]) AND ((tbl_element.element)="Element 1"));

    I have used this query to create a form, the problem is that I cannot add any new rows ?

    Any suggestions ?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    The data engine must have a unique means of identifying each row in each table, it must also reference all required fields unless they have deault values.
    Is their a way in which you can simplify the SQL.

    Classically you would have a single table underlying a single form, so you would map your parent form as the top level, and then drop down with sub forms if required for child tables.

    Personally I've never tried to insert new records using a joined query in Access.

    Another alternative may be to use an unbound form, set values as required, and then write the values to the resepctive tables.

  3. #3
    Join Date
    Jun 2003
    I have used this query to create a form, the problem is that I cannot add any new rows ?
    Before using a query as the recordsource for a form you may want to check in query design mode that indeed you can add new records to the query. Usually when you can add new records to the query you see a blank row at the very bottom of the query.
    J. Paul Schmidt, Freelance Web and Database Developer
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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