Form opens on Date Query

[KLewisBPM]

Does anyone know how to set a date query running when a user opens a form.

When a form opens I would like it to check the system date against a date field in a username table. If the username date is in the past a form will open saying "Your username has expired please contact your Administrator"

Seems a simple logic, but possibly a complicated task!

Any help would be grateful.

Kind Regards

Kelley Lewis

 

[jiqjaq]

You need to put the query in VBA code in the Form_Open event. If the username has expired you can set Cancel = True and Exit Sub. That will stop the form from finishing the opening process, so it will never actually open for this condition.

 

[shogun0803]

Are you in the U.S? If so, call me at 703-248-2100 and ask for Rick Smith

This is easy but have to ask some questions.

Network Security( CCNA, CISSP)
Sell Shopping Cart/Merchant Account
Access Expert
rsmith@litsllc.com