First of all, thank for all help regarding my previous posts... they have been very helpful. Here's my next problem...

I have a query the involves 3 linked tables so I cannot perform updates on a record in one of the tables. Darn! Is there a way to somehow mark the records I want to change (from the subform, in datasheet view -maybe change the color of a row) and then go to a produre to update them. I have some knowledge in VBA, but I don't know where to start with this one.

Thanks.

[This message has been edited by nelslynn (edited 12-09-2001).]

Just because a query links three tables does not mean that you can't update through it. Marking the records is the same as updating them. See if you can figure out why the query is not updateable. Do each of the three tables contain a unique index? Look up "when can I update data from a query" using the office assistant. Also try this link for an article titled - "Harnessing the Power of Updatable Queries":
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnima99/html/abcado.asp

Thanks, Pat for your reply.

My query is not updatable, I think, because I am using three tables(I've read previous post that you can't update tables if they are involve in a query with 2 or more tables). I am also using a calculated field, so this could be a reason too.

I will read up on the link you provided, it seems over my head, however. Could you however, confirm that I can somehow do the following.

I have a subform on a mainform. The query in question shows the results in the subform... those are records from one table and a calculated field (which is just for viewing). All I want to do is change a yes/no field of CURTAIN records in the one table. When I try to click on the check box, I get "record can't be updated". Do I need to go to VBA programming for this? If so, how do I mark the record I want to update the yes/no field??

Thanks for you help.

I have many updateable queries with more than three tables in them. Try setting the distinct rows property of the query to yes.