New user warning!!

[rockyjr]

Access 2007

I have a query that checks for New Accounts:

SELECT Customers.ID, Customers.[Last Name], Customers.[First Name], Customers.[New User]
FROM Customers
WHERE (((Customers.[New User])=True));

What I would like is a flag created on a form to let me know that there's a new account waiting for me to activate.

It could be a light, or a picture that enables... I dont mind, I just dont know where to start on that one.

Any help would be great!!

Lucas

 

[KenHigg]

Maybe you could use dcount() along with the form timer event to turn a label on / off...

 

[rockyjr]

cool, thank you!!!

That actually worked great!!

 

[KenHigg]

Cool - Glad to help.