Sorry to take so long to reply but my son was born later on the 11th.



You stated that "CurrentStaffID" is a variable. Is it in a stand alone table that is overwritten each time a user logs in or is selected? Basically, I am trying to figure out how you are populating the field "currentStaffID".