let a form look to a checkbox in a table

[Lightlancer]

hi there,

i have alot of forms in my database and now they must look into a table (tblstatus) if this form is enabled or disabled for users, i know to put this in the onload or on open event, but what code do i need to use, to let the form look into that table and look for a field and then if checkbox is True, then continue if its False, the form must be closed and a msgbox must appear to tell the user, this form has been disabled by Administrator

Any ideas?

Lightlancer

 

[genomon]

Have a look at the DLookup() function in Access help.
Maybe set Cancel = True in the Form Open event?

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."