Loosey: Is the checkbox bound to a field in the table? If so, you can make an update query. If you're new to SQL then the QBE is probably the way to go.
If the checkbox is not bound to a field, then you can bind it to an expression (this would be the same expression that you use in your update query, actually). The expression would be: =[RenewalDate] < Date() This expression evaluates to TRUE if the renewal date is earlier than today, resulting in a checked checkbox. It evaluates to FALSE if the renewal date is today or later, giving you an unchecked checkbox. Good luck, Peter Hoogenboom --- In [EMAIL PROTECTED], "Loosey" <[EMAIL PROTECTED]> wrote: > > Hi, > > I am going round in circles and unfortunately don't know enough > about the query builder or SQL (or if these are even going to help!) > to resolve my issue. > > I have a club membership database which i have made (steep learning > curve for me so far!) which I need some help with, if anyone could > help with the below I would be eternally grateful. > > I have a form in which I have inseted a check box for lapsed members > however I would like to have an auto-calculation (if possible) so I > do not have to manually mark people as overdue/lapsed. > > Can I put a macro or something in the form that will cross reference > the renewal date and todays date and mark the record lapsed (by way > of the check box?)if the date today is later than the renewal??? > > Is there anyway this can be done? And if so, help with the code/how > to do it would be greatly appreciated. > > I have looked online but everything I have tried so far has failed > miserably! >
