These problems are all linked and help with any of them would be great thanks. Not all of them are specifically about queries but I thought this was the best forum for it.

My database is VERY simple and it manages buyers, properties for sale, and sucsessful purchases for an estate agent. On the property table I have a Yes/No check box. When yes it shows that the property has been sold. I would like to know how this could be automatically changed to yes when the record is property is added to a new purchase record.

I'm creating a query that matches up buyers requirements to property details. For example, in the buyer table I have a field called 'Property Type'. If I run the query from the buyer form, it shows all the propertiy records that have the same 'property type' as that buyer record (but it will be for more than one record).

Finally for that same query, I would like it to IGNORE all properties that have the Sold box checked. So similar to putting that field in the query but basically the opposite.

I hope you understand my explinations and if anyone can help it would be great. Thanks :D