Browse through record at opening

A

Antonio

Hello, everybody. Here's what I am trying to do: when a
user opens the database, I would like it to go through all
the record and put a checkmark in a Inactive account
checkbox if the subscription date is < 0. Can somebody
help me? thanks. Antonio
 
D

Douglas J. Steele

Write an Update query that sets the Inactive Account field to True when the
subscription date is < 0 (whatever that means), and run the query when you
open the database.

It's seldom ever better to loop through a recordset when a single SQL
statement can do the same thing.
 
A

Antonio

Doug, thank you for your time, but the field that's
checked it's unbound...it's the difference of the
subscription setup date and the subscription expiration
date. That's why I was going to put a code to run at db
opening. Antonio
 
D

Douglas J. Steele

The query can calculate the difference, using DateDiff and the Date
function.
 
Top