Browse through record at opening

  • Thread starter Thread starter Antonio
  • Start date Start date
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
 
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.
 
Antonio said:
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
Click to expand...

Let access do that for you, don't bother with doing that kind of thing
manually. A update query which runs automatically when the database is
opened would do it.
 
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
 
Back
Top