Sorry, but the above statements are mutually exclusive! If the fields on your form come from multiple tables it is based on a query! You may not have sat down and designed a query, but one of the Access Wizards has done this, using the fields you've selected from the multiple tables. If you go to the Data Tab on the Properties Pane, for the Form, and look at the RecordSource, you should see a SQL Statement for the Query. Most multi-table queries are Read-Only, as yours apparently is.
Originally Posted by mkjsmith
Are your tables in a one-to-many relationship? The usual workaround is to use a main form for your one side of the relationship and a subform for each of the many-side tables, joined by a common field that is the Primary Key in the main table and a Foreign Key in the many-side tables.
Last edited by Missinglinq; 04-06-14 at 14:07.
Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007