Record set not updatable

  • Thread starter Thread starter tm3025
  • Start date Start date
T

tm3025

I have created a form originally based on a table with personal info. I
decided to add fields from a linked table to the form. Everything was working
fine until I tried to add a new record and now I have found that I cannot
even edit the data, it's basically just a viewer. I have checked some other
posts but they have not helped.

In form properties, data entry is set to yes and RecordSet Type is dynaset.
When I look at the RecordSource and go into design view and then spreadsheet
view, I cannot add a field. Is there a way to fix this so that I can add
records with the form?
 
Your table is not editable so your form is not either. You need to come up
with a table that you can edit and then add the data.
 
If you can edit both of the tables individuallly, it is most likely the
combination of tables that makes it uneditable, not the table itself. Or it
could be something about the form, but most likely it is because of the
added table fields. How did you add fields from the linked table? Do you
mean the form's record source is a query? If so, can you edit the query
directly (that is, by opening the query and trying to edit it, which is
different than being in datasheet view for the form)? If not, see here for
some possibilities:
http://allenbrowne.com/ser-61.html

If the query contains two tables that are in a one-to-many relationship you
should use a main form based on the "one" table with a subform based on the
"many" table (or better yet, queries based on the tables).
 
Yes, I can edit both tables individually. I tried making another form from
scratch in which I added all of the fields manually in case it was something
about the way I created the form that messed it up. This form was also not
updatable. I didn't create a query as the record source for the form but if I
go to properties of the form, there is a record source query. I can open it
and edit it, but I don't know what to do once there. I have tried changing
the join properties, but no combinations I use work. As for the tables I am
using, there is a one to many relationship between the primary key of one of
my tables and a foreign key in the other. I have been trying to make a tabbed
form instead of a subform because I have too many fields based on the "many"
table.
 
Back
Top