Editing or adding records in a form

T

tiz

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
 
C

ChrisJ

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.
 
T

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?
 
C

ChrisJ

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.
 
J

James

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
 
R

Rita44

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!
 
C

ChrisJ

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
 
C

ChrisJ

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
 
B

Bobk

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.
 
Y

Yula

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
 
Top