Editing or adding records in a form

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

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.

"tiz" wrote:

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

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

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.

"ChrisJ" wrote:

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.

"tiz" wrote:

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

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

"ChrisJ" wrote:

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.

"ChrisJ" wrote:

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.

"tiz" wrote:

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

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

"James" wrote:

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

I have the same problem as Tiz. However, I have no idea what you mean by
"Paste the SQL for the form's recordsource into a query window and see if you
can update that." Please explain! Help menus were no help. Thanks!


"ChrisJ" wrote:

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.

"tiz" wrote:

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

Open your form in design mode and display the properties window.
Select the "data" tab and look at the "record source" setting
If the form is "bound", this setting will be the name of a table, query or
an sql statement (hand-written query).
My previous answer assumes that the record source is an sql statement.
In this case, copy the contents of this property.

Open a new query window.
Click OK to go to the design view.
In the "show table" window, click "Close" without selecting anything

On the lefthand end of the toolbar, click the bold "SQL" button.

A new SQL window will open with "SELECT;" highlighted.
Replace this with what you copied from the properties window.

Run the query, and see if you can enter or change data

Chris

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

Thanks

"ChrisJ" wrote:

Open your form in design mode and display the properties window.
Select the "data" tab and look at the "record source" setting
If the form is "bound", this setting will be the name of a table, query or
an sql statement (hand-written query).
My previous answer assumes that the record source is an sql statement.
In this case, copy the contents of this property.

Open a new query window.
Click OK to go to the design view.
In the "show table" window, click "Close" without selecting anything

On the lefthand end of the toolbar, click the bold "SQL" button.

A new SQL window will open with "SELECT;" highlighted.
Replace this with what you copied from the properties window.

Run the query, and see if you can enter or change data

Chris

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

"Jools" wrote:

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

Thanks