May 24 2020 07:57 AM
I'm a new user of Access. I've developed a database to manage the membership of a small fishing club. I've used it once in anger and my problem is that it is too quick and easy to use! I find that I race ahead and then forget whether I have updated all of the fields; in particular has the member renewed! What I need is a way to stop myself proceeding until I've completed everything. Ideally there would be something that perhaps shows (in a different colour?) that a field had not been updated. Either that or perhaps something that simply stopped me proceeding until everything had been checked and updated. Your advice or suggestions would be gratefully received.
May 24 2020 08:18 AM
@Matthew328
Perhaps the solution would be to make some fields required at the table level. That way, you'll get an error if you try to save a record with one or more of those required values missing.