An 'Update Record' Form

[shadowspell]

I have a form I want to use to update records in my database. I don't want to use the same form as I do to enter new records.

The form is based on a query where some fields have a criteria.

I have found that I cannot update the fields that have a criteria.

I am using four tables. Three of the table have a relation to the one main table. I do not enforce referential integrity since this would not be expediant.

There must be a way to construct this query to allow me to update fields that have criteria. Can someone help?
Thanks,
Chris

 

[shadowspell]

- you must like living on the edge. Who cleans up the bad data, you or the user or does the user just make poor business decisions because his data is unreliable?

You'll need to post the query if you want help with it.

Well, Pat, I don't really think I'm on the edge in this case. It isn't always necessary or desireable to enforce referential integrity. But discussing theory is not what I'm here for. How do I post the query?
Chris

 

[shadowspell]

Change the query to SQL view, copy the SQL statement, and paste it into a reply to this post.

Here is the SQL: Thanks again:

SELECT [WMAG Work Requests].Status, [WMAG Work Requests].WorkRequestNumber, [WMAG Work Requests].DateSubmitted, [WMAG Work Requests].DesiredDueDate, [WMAG Work Requests].ProductOrService, [WMAG Work Requests].ShortDescriptionOfWork, [WMAG Work Requests].WorkReqDoc, [WMAG Work Requests].URL, [WMAG Work Requests].DevNotes, [WMAG Work Requests].DevPortalChange, [WMAG Work Requests].DevPortalUserProfile, [WMAG Work Requests].DevID, [WMAG Work Requests].Posting, [WMAG Work Requests].PostingNum, [WMAG Work Requests].PostingTypes, [WMAG Work Requests].PostingTypesNum
FROM Status INNER JOIN ([WMAG Web Developers] INNER JOIN [WMAG Work Requests] ON [WMAG Web Developers].DevID = [WMAG Work Requests].DevID) ON (Status.Status = [WMAG Work Requests].Status) AND (Status.Status = [WMAG Work Requests].Status) AND (Status.Status = [WMAG Work Requests].Status) AND (Status.Status = [WMAG Work Requests].Status)
WHERE ((([WMAG Work Requests].Status) Not In ("Completed") And ([WMAG Work Requests].Status) Not In ("Complete")) AND (([WMAG Work Requests].DevID) In ("1")))
ORDER BY [WMAG Work Requests].DateSubmitted;

I am unable to change the value of ([WMAG Work Requests].Status)
and I am unable to change the value of ([WMAG Work Requests].DevID)