Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2014
    Posts
    5

    Angry Unanswered: Access subform with additional field but not editable

    I created an instructor form with a sub form table on the bottom - http://oi62.tinypic.com/20sa83m.jpg

    I would like to add columns in the subform from the instructor_info subform but it should not be editable, just display it as per the column relationship key, and the relationship key for the 2 tables (instructor_info & course_table) is course_id.

    <h2>Course Table</h2>
    - Course Date (instead of Course)
    - Course Location
    - Station Demo
    - No. of Teachings
    - Hours Taught

    <h2>Instructor Teaching Info Table</h2>

    - Instructor ID
    - Alone
    - Course
    - Course Date
    - No. of Teachings
    - Course Type

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    set the sub forms properties as required
    http://office.microsoft.com/en-gb/ac...005188538.aspx
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2014
    Posts
    5
    got it! 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
  •