Editing or adding records in a form

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.

"ChrisJ" wrote:

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

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

"ChrisJ" wrote:

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