Okay, now that makes sense. if it is stored in a table it wont be updated. If it is in a query form linked to [status] it will always be in an updated state.
That sounds good and stuff but how would this query work?
I'm really sorry for being a noob :banghead:
Aah, I don't want it as a query since this Status information needs to be on every form I have just to remind the user of this specific candidates status.
Many thanks for your swift response. It is much appreciated :)
Your solution does make some sense to me however, I have literally no idea how i would go by implementing this. I am a complete beginner who has been given this very stressful task!
Hi All,
I have little to no experience with access. However, I have managed to create a small recruitment database.
I am trying to get the status of the candidate to update automatically depending on what stage they are at of the recruitment process. (this may have been answered before but...