Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2013

    Unanswered: Are "Multiple Item" forms editable?

    This is my first post to this forum. Thanks for any assistance you can provide.

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    The 'Multiple Items Form' is just another term the Boys of Redmond added, for who knows what reason, with versions 2007/2010. Clicking on the MIF Icon simply automatically creates a Continuous View Form with the data arranged laterally, like a Datasheet View Form, based on the Record Source (Table or Query) that was highlighted when the MIF Icon was clicked.

    Whether the type of Form can be updated depends, as do all types of Forms, on whether or not the Record Source can be updated.

    Forms based on single Tables, or Forms based on Queries that are, in turn, based on single Tables, can be updated.

    Forms based on Queries that are, in turn, based on Multiple Tables, sometimes can and sometimes cannot be updated. For reasons why Multi-table Queries cannot be updated, have a look at Allen Browne's article on the subject:

    Microsoft Access tips: Why is my query read-only?

    Welcome to the dbForums!

    Linq ;0)>
    Hope this helps!

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

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Mar 2013


    Thank you for the link to the Microsoft Access tips and for the explanation. I think my problem is the joins I used because I am working with 4 tables and I'm not sure of the relationship joins. I'll have to play around and see what I can get to work.

Posting Permissions

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