Trivial trouble with subform frustrating me

[sgottfried]

I am working on a user interface whereby I have ID, title, dates in the main form (among other things). The subforms on this main form are linked by ID to one subform for people and their organizations and roles and another subform to the platforms and their types. Each subform is based on a select query but the first one has three tables in the select while the other only has two.

I need for the user to be able to enter data into the fields in the subforms and have that data added to the tables.

This is working fine for the second subform (platforms and platform types). The subform is obviously in "add mode" because there is the new record * shown in the top row.

The first subform (people, organizations, roles) will not accept any input. There is no * shown and you can't put your cursor in the subform. I have spent hourrs examining every property list and can't find a difference between them anywhere.

If there already is data, the data are found, but not editable.

What am I missing?

 

[missinglinq]

Allen Browne has an excellent article that explains why Multi-Table Queries are frequently Read-Only:

Why is my query read-only?

Linq ;0)>

 

[sgottfried]

Thanks for that article. That is informative and a good resource. Unfortunately, none of those things apply in my case.

 

[boblarson]

Thanks for that article. That is informative and a good resource. Unfortunately, none of those things apply in my case.

Why do you have 3 tables in the record source of a subform? It should really only have ONE table. You don't need to include the tables for lookup items as you use a combo box or list box on the form to display the looked up value but to store the ID equivalent in the one table. This is a common mistake. Another common mistake people make is including the table from the main form's Record Source. You should NOT have the table from the main form's record source in the subform's record source nor should you have the subform's table from its record source in the record source of the main form.

 

[sgottfried]

Thanks, you are probably on to something. I'll rework things and report back.

 

[sgottfried]

OK, you were right. That works. I have another subform that uses a query and it works, so I was totally thrown off. I will change that one now as well. Thanks so much!!!