Editing or adding records in a form

[Guest]

I created a form to input data into several different tables. I am unable to
add new records in the form view. I cannot even edit records in the form.
Whenever I'm in the form view and try to edit a record it seems as if it were
locked. I have checked the properties of the form about ten times now, Allow
Edits is Yes,
Allow Deletions is Yes, Allow Additions is Yes. Record Locks is on No Locks.
Recordset Type is Dynaset, etc. Can somebody help me?

Thanks,
tiz

 

[Guest]

Presuming the form is bound to a query, it is likely that the query is not
updatable.

Paste the SQL for the form's recordsource into a query window and see if you
can update that.

 

[Guest]

I checked the form's record source and it is not updatable. How can I change
the recordsource's property to make it updatable?

 

[Guest]

You can't. If Access decides the query is not updateable, you're stuck with it.
However, if you post the SQL of the recordsource query, we may be able to
suggest a way to help you achieve what you want.

 

[Guest]

Hi: ChrisJ

I have same problem.

My front end form using a query and gets data from two tables, the tables
are located in another computer (Access tables).

Before, this form can add new record, Edit..., but today, all my staff
(including me) the form just can't do that, even set Edit is true.

If I go to open the tables in the back end, I can add new record (there is a
* indicating add new), but if I run the query from my front end, I just can't
add new record. (there is no * indicting add new).

Please let me how to solve this problem.

Thanks.

James

 

[Guest]

This is not the same problem. In Tiz's case the form never worked. In your
case it did, but suddenly stopped working.
Something must have changed to cause this.
The most likely causes, if everything else is still working, are
Database corruption or security issues

 

[Guest]

What do I do if this does not allow any editing or changes?

Thanks

 

[Guest]

Post the SQL of the form's recordsource, and we may be able to tell you how
to fix it. You may need to go to a form/subform setup

 

[Guest]

I had the same problem - A perfectly running form that was being used for
data entry and editing stopped working. It acted like edit, add and delete
were turned off. I tried everything I could think of and then came here to
see if anyone else had the same problem. It was suggested that the query was
not allowing the update. I checked my query and it was set as a select query.
I Changed that to be an update query and then re-selected the select query
option. I then tried my form and it worked ok.

 

[Guest]

SELECT Main_Table.Inserter, Main_Table.Date, Main_Table.Meter,
Main_Table.Shift, Main_Table.Category, Main_Table.Job, Main_Table.ID,
Main_Table.Count, Main_Table.Postage, Main_Table.MasterItem1,
Main_Table.PSItem1, Main_Table.Description1, Main_Table.Price1,
Main_Table.MasterItem2, Main_Table.PSItem2, Main_Table.Description2,
Main_Table.Price2, Main_Table.CostCenter, Main_Table.Contact, Main_Table.OH,
Main_Table.Post, Main_Table.Total
FROM Main_Table;

Any suggestions? I can't add new records! Please Help