Hello readers,
In my db (I am a beginner) users will add records to a table through a form in a navigation form. When the nav form opens, the cursor is not located in the fields of the sub form (first tab). Fine, the user can select other sub forms.
When the user accidentally puts its cursor in one of the fields without writing anything at all, fine, he can still select other sub forms in the nav form.
My problem:
However, let's say, my user starts writing in the sub form and then realizes that he/she made a mistake and wants to check in the "search" sub form something or perform another action. In this case, he/she will not be able to do so without having to close the nav form or db because I put a code on the sub form (Before Update, from this useful website http://www.databasedev.co.uk/validate_textbox.html )
Everytime he would try to simply go to the other tab, it would pop up the error message from the code. Even if he erases what he wrote in the beginning. This code checks that some of the fields are filled correctly before adding the record to the table.
Question:
I think this is me being picky but I am trying to make this form as user friendly as possible... Is there any way to correct my problem?
I did find that this code alternative was better than setting "Required" to yes in the chosen fields at the table level which was not giving a very user friendly message.
Any guidance is well appreciated!
Thank you,
Aucho22
In my db (I am a beginner) users will add records to a table through a form in a navigation form. When the nav form opens, the cursor is not located in the fields of the sub form (first tab). Fine, the user can select other sub forms.
When the user accidentally puts its cursor in one of the fields without writing anything at all, fine, he can still select other sub forms in the nav form.
My problem:
However, let's say, my user starts writing in the sub form and then realizes that he/she made a mistake and wants to check in the "search" sub form something or perform another action. In this case, he/she will not be able to do so without having to close the nav form or db because I put a code on the sub form (Before Update, from this useful website http://www.databasedev.co.uk/validate_textbox.html )
Everytime he would try to simply go to the other tab, it would pop up the error message from the code. Even if he erases what he wrote in the beginning. This code checks that some of the fields are filled correctly before adding the record to the table.
Question:
I think this is me being picky but I am trying to make this form as user friendly as possible... Is there any way to correct my problem?
I did find that this code alternative was better than setting "Required" to yes in the chosen fields at the table level which was not giving a very user friendly message.
Any guidance is well appreciated!
Thank you,
Aucho22
Last edited:
