G
Guest
I am hoping this might be the right place to ask!
I have a form and a subform. The form holds employee information and
contains a field for department (which classifies an employee based on the
department for which they are assigned). The subform contains working hours
and also contains department information. The reason for this is that an
employee may do hours for another department.
The problem is best given by an example: an employee under manager A does
some hours in another department under manager B. Manager B needs to make
sure that any hours worked is authorised to keep a check on budgets for each
costcentre (Manager A may want to put down hours under another department so
they aren't spending their own money!)
For the last few weeks I have wondered how I might be able to achieve a
possible solution for this but I need some help to decide whether its
possible. I want to write some code which says that if the department
information in the form and subform are different, a form pops up. If the
password is correct then the "department" field in the subform stays,
otherwise the field is turned blank. I can find a possible solution for the
table and form here
http://www.databasedev.co.uk/login.html
but I need some help with code to open the form based on the comparison.
Is it possible?
I hope this makes sense. If it doesn't, just ask.
cheers in advance
I have a form and a subform. The form holds employee information and
contains a field for department (which classifies an employee based on the
department for which they are assigned). The subform contains working hours
and also contains department information. The reason for this is that an
employee may do hours for another department.
The problem is best given by an example: an employee under manager A does
some hours in another department under manager B. Manager B needs to make
sure that any hours worked is authorised to keep a check on budgets for each
costcentre (Manager A may want to put down hours under another department so
they aren't spending their own money!)
For the last few weeks I have wondered how I might be able to achieve a
possible solution for this but I need some help to decide whether its
possible. I want to write some code which says that if the department
information in the form and subform are different, a form pops up. If the
password is correct then the "department" field in the subform stays,
otherwise the field is turned blank. I can find a possible solution for the
table and form here
http://www.databasedev.co.uk/login.html
but I need some help with code to open the form based on the comparison.
Is it possible?
I hope this makes sense. If it doesn't, just ask.
cheers in advance