In the process of working on my application today, a thought occurred to me as I was testing things.
While testing I get the "You must enter a value in *table* field" a lot. Mostly due to the incomplete nature of the application. Things are still being built after all, so it's to be expected.
However, I have certain entry forms that even though they are mostly complete, could still cause that error due to a user possibly getting ahead of themselves with entering data, or maybe pressed tab one too many times and didn't notice. Certain fields on my forms REQUIRE data entered in other controls first (I have tried to layout my forms and tab numbers so it makes the users "flow" in the direction I want).
On a post I made earlier today (I was working on a form with list boxes, combo boxes etc), a user would have to pick a field in the list box, then pick a value in the combo then enter another value in a text box. Things essentially HAVE to go in that order. However, what if the user forgets to pick an item in the list box first and tries to interact with the combo? It throws that "must enter value" error (and the only method I have used to "fix" it is to completely close the form), but that is horrible practice for an end user.
So my questions is this, can you do a Before Update event that invokes OnError to help remedy that? Say if the user accidently breaks the order they are supposed to go it, before they cause that error and get stuck a message box pops up and says hey, you need to do this over here first. I'm sure I could probably come up with a VBA error handler, but the macro builder has the OnError, so I assume Access has built in features to deal with this.
While testing I get the "You must enter a value in *table* field" a lot. Mostly due to the incomplete nature of the application. Things are still being built after all, so it's to be expected.
However, I have certain entry forms that even though they are mostly complete, could still cause that error due to a user possibly getting ahead of themselves with entering data, or maybe pressed tab one too many times and didn't notice. Certain fields on my forms REQUIRE data entered in other controls first (I have tried to layout my forms and tab numbers so it makes the users "flow" in the direction I want).
On a post I made earlier today (I was working on a form with list boxes, combo boxes etc), a user would have to pick a field in the list box, then pick a value in the combo then enter another value in a text box. Things essentially HAVE to go in that order. However, what if the user forgets to pick an item in the list box first and tries to interact with the combo? It throws that "must enter value" error (and the only method I have used to "fix" it is to completely close the form), but that is horrible practice for an end user.
So my questions is this, can you do a Before Update event that invokes OnError to help remedy that? Say if the user accidently breaks the order they are supposed to go it, before they cause that error and get stuck a message box pops up and says hey, you need to do this over here first. I'm sure I could probably come up with a VBA error handler, but the macro builder has the OnError, so I assume Access has built in features to deal with this.