Originally Posted by
John_G
How did you use more than one table on your subform without using a query as the record source for the form...
John's being rhetorical, here! If Fields from multiple Tables are involved, the Form 's RecordSource has to be a Query! There's no way around that! It may be one the Access Gnomes created, based on the Fields you asked them to include, but it is a Query! And many multi-Table Queries are Read-Only.
In Form Design View
- Go to Properties - Data
- Go to the Record Source Property and click on the ellipsis (...) to the right of the box and dropdown arrow
- You are now in the Query Design Grid
- Now click on the big red Exclamation Mark titled 'Run'
- Now try to enter data in one of the Fields
If you cannot do this, the Query is Read-Only.
Allen Browne has an excellent article that explains why Multi-Table Queries are frequently Read-Only:
Why is my query read-only?
The standard method for displaying data from multiple-Tables, while retaining the ability to enter/update the information, is to use a Main Form/Subform configuration, as you're already doing. You may have to 'nest' another Subform within your current Subform, or use two Subforms, each linked to your Main Form.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007