Update qry - Operation must use updateable query

[lgbatdw]

Using A2003 and trying to run this update qry, but get 'Operation must use updateable query'. I know there is a way to not use a join, but not sure how. Any suggestions?

UPDATE [Check Writer] INNER JOIN CheckWriterEntriesWithGLAccts ON [Check Writer].[Trans ID]=CheckWriterEntriesWithGLAccts.[Trans ID] SET [Check Writer].[Batch Post] = True
WHERE ((([Check Writer].[Account Number])=Forms![Check Writer Batch Post]![Bank Account Number]) And (([Check Writer].[Check Date]) Between Forms![Check Writer Batch Post]![Start Date] And Forms![Check Writer Batch Post]![End Date]) And (([Check Writer].Void)=No) And (([Check Writer].[Bill Payment])=No) And (([Check Writer].Posted)=No));

Linda in MN

 

[dhookom]

Is CheckWriterEntriesWithGLAccts.[Trans ID] the primary key field?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

You may try this:
UPDATE [Check Writer]
SET [Batch Post] = True
WHERE [Account Number]=Forms![Check Writer Batch Post]![Bank Account Number]
AND [Check Date] Between Forms![Check Writer Batch Post]![Start Date] And Forms![Check Writer Batch Post]![End Date]
AND Void=No AND [Bill Payment]=No AND Posted=No
AND [Trans ID] IN (SELECT [Trans ID] FROM CheckWriterEntriesWithGLAccts)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lgbatdw]

Thanks PHV, it worked like a charm!

Linda in MN