To be certain, post your query including its where clause. I'm not certain if it's still true, but in the past a bad where clause, rather than returning an error, would cause the update to act on all the records in the table.
Ben Petersen On 20 Dec 2001, at 14:34, [EMAIL PROTECTED] wrote: > I have a view I created off of two tables. When I try to update a field in a record >in the view either > through a query or a form, it updates all records with that field. Help. > > When I use the query, I do specify a "where" clause. The other case is using a form >to just edit that field. > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
