Form Data Locked

[Xfree]

I have a form based on a query with 2 tables that are joined already. this
form has become locked for edit. I have checked the enabled and locked
settings in the form and they are set correctly. I have reviewed several
posts on this subject so I check my query and tried to change things around
to see if I could isolate it but I was unable. I have been able to track it
back to the daily backup where it stopped working and there was a change made
which was the addition of one field. I tried to remove this field and it made
no difference, I cannot even edit the query results in a data sheet.

Any ideas?

 

[Xfree]

No it is not editable but it is on the prior version on the backup.

 

[Xfree]

No I can not edit the data directly in the query and the two tables are
joined by their primary key.

Sorry, let me make sure I communicated my question correctly: can you edit
the data directly in the query? Are the fields that the tables are related
on primary key?

Bonnie
http://www.dataplus-svc.com

No it is not editable but it is on the prior version on the backup.

Is the query editable?

[quoted text clipped - 11 lines]

Any ideas?

 

[Xfree]

What is the best way to post the query?

Make sure you check the tables and verify that the key's are there. Post the
query please - if I can't help somebody else will ask for it anyway.

Bonnie
http://www.dataplus-svc.com

No I can not edit the data directly in the query and the two tables are
joined by their primary key.

Sorry, let me make sure I communicated my question correctly: can you edit
the data directly in the query? Are the fields that the tables are related

[quoted text clipped - 10 lines]

Any ideas?

 

[Xfree]

Here is the SQL info from the query.

SELECT PourScheduleSub.PourScheduleSubID, PourScheduleSub.ProductID,
Products.[Part Number], PourScheduleSub.NumbMolds, Products.[Pour Wt],
Products.NumberOn, [NumbMolds]*[Products]![Pour Wt] AS Expr1,
PourScheduleSub.PourScheduleID
FROM Products INNER JOIN PourScheduleSub ON (Products.ProductID =
PourScheduleSub.ProductID) AND (Products.ProductID =
PourScheduleSub.ProductID);

Oh sorry. In your query designer, click on VIEW - SQL VIEW and copy the SQL
code.

Bonnie
http://www.dataplus-svc.com

What is the best way to post the query?

Make sure you check the tables and verify that the key's are there. Post the
query please - if I can't help somebody else will ask for it anyway.

[quoted text clipped - 10 lines]

Any ideas?