ACCESS 2007 Form data Entry problem

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

I created a form based on a table I had created.
I am unable to enter data into the fields on the form I am also unable to
edit existing data. What shoudl I do to enable entry?
 
Is your table or query you are running the form from editable? The gray arrow
and asterisk have to be highlighted. If your table or query are not editable,
your form won't be either.
 
Thanks for the input.
Somehow I think it had to do with relationship between tables that I had
established, tho I don't understand why. I deleted a table that I had linked
to the primary table and then I could create an editable form.
 
Thanks for the input.
Somehow I think it had to do with relationship between tables that I had
established, tho I don't understand why. I deleted a table that I had linked
to the primary table and then I could create an editable form.
Click to expand...

If you have multiple tables to update, your best bet is to use a Form for the
"one" side table with one or more Subforms for the "many". Creating One Great
Master Query and basing a form on it is not usually a good idea! Often the
multitable query will not be updateable, and if it is you will get strange
results (duplicate records, or some fields being updateable and some not).
 
Back
Top