Access subform with additional field but not editable

[kinsesyete]

I created an instructor form with a sub form table on the bottom - [pic at the bottom]


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.


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


Instructor Teaching Info Table
- Instructor ID
- Alone
- Course
- Course Date
- No. of Teachings
- Course Type
- Notes

[burrina]

Do you mean allow new records but not be able to edit the ones already saved?

[June7]

Not clear to me what you are asking for. You don't want the course records editable? Set form AllowEdits, AllowAdditions, AllowDeletions properties to No. Or set the subform container control Locked property to Yes, or Enabled property to No.

How do you want to add new course records?

[kinsesyete]

Hi sir,

Thanks for the reply. I want to add columns below but only view it, basically the SQL a field for example is SELECT [Course Table].course_date FROM [Course Table] WHERE course_idColumn = [Course Table].course_id;
For example, course date would be different per row since the course_date info is connected with the [Course Table].course_id

- Course Date (instead of Course)
- Course Location
- Station Demo
- No. of Teachings
- Hours Taught

[June7]

Options for displaying related info from another table:

1. multi-column combobox

2. include table in the form's RecordSource with LEFT or RIGHT join (not INNER) - don't allow edit of the related info field, set textboxes as Locked Yes, TabStop No

3. DLookup() expression

[kinsesyete]

Hi,

is this right?

SELECT[Instructor Teaching Information Table].instructor_id,
[Instructor Teaching Information Table].alone, 
[Instructor Teaching Information Table].course_id,
[Instructor Teaching Information Table].course,
[Instructor Teaching Information Table].num_teachings,
[Instructor Teaching Information Table].course_type,
[Instructor Teaching Information Table].notes,
[Course Table].course_date,
[Course Table].location,
[Course Table].station_demo,
[Course Table].hours
FROM [Instructor Teaching Information Table]
RIGHT JOIN [Course Table]
ON [Instructor Teaching Information Table].course_id = [Course Table].course_id;

But it shows me Type mismatch in expression

[June7]

Mismatch on the course_id fields?

I don't know your data structure. If these are properly related primary and foreign key fields the query should work.

[kinsesyete]

this is the data structure:

[June7]

You are not linking the tables on course_id. You are saving course_name into Teaching Information.

None of your links are on the designated primary key ID fields. None of the ID fields values are saved as foreign keys. The ID fields are useless with this arrangement.