i have a query that has records based on true. i want to change these values to false when a user hits a button....i could make a macro to update this query but im lost is this what i should do...and how or is there another solution

Are you trying to update all the records in your query? If so, change it to an update query. You can then use a macro/vba to run the query.