Coding in Access

[jrsarrat]

Using Access, I have created a form for employees to log in at the start of their day, log out for lunch, back in from lunch; and lastly, log out at the end of their day. What I want is to create a command that will automatically highlight the next button for them to click, based on their previous login (In, Out for lunch, return from lunch, End of day). Is this possible? Your guidance is much appreciated!

 

[welshgasman]

I wasn't thinking so much in restrictions, just setting the default for the user and perhaps prevent missing entries.?

 

[welshgasman]

The wizard will ask where you wish to store the value, so select the correct field.