Making at least one record required.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an employee information form that has a yes/no checkbox for the
employee to be an administrator. There must always be at least 1
administrator or they will not be able to login to the options section(which
is where the employee form link is located). What would you put in the
beforeupdate section to not allow a user to save a record unless there is at
least 1 admin?

thanx
 
James,

This could not happen with a new employee record, right? This could
only happen if you are editing the record for an existing employee who
happens to be the only currently assigned Admin, and you remove the
admin status from this person. Do I understand correctly?
 
Correct. The database is started with an employee record called admin with
the admin check box = true. I want them to be able to delete the admin
record but only if one or more records has the admin check box = true.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Makeing at least one record required! Re-post 3
Combo showing non current employee 2
Form Sorting and Adding Records 1
Posting records to a join table 3
Required Fields for New Form/Record 3
Command Button to Add Several Records 3
make the value of one control dependent on another 5
Access Employee testing checklist 0

Back
Top