i am making a db for a gym. the members pay yearly and the fact that they have paid is shown by a tick box in the members table. i therefore want to reset these boxes to 'No' at the beginning of each year. anyone got any way that this could be done.
thanks

Just create an Update query in the QBE grid and under Update type FALSE.

thanks. ive done that now and it works great. however, is there any way that i can automate it to update on the 1st January every year

I'm sure that there's more than one way, but the easiest I could think of is to have a table that stores the current year, then when your form opens it pulls the value using a DLookup and compares it against the current year. Using an If statement you run the query if it doesn't match and then update the table with the current year.

cool. thanks for the pointers. i'll go and give that a try