Thank you John. I will work on using the BeforeUpdate event in my development database. I have a small group that does my beta testing before I release to the masses.
I do have a question though...I have roughly 150 users (a.k.a. "the masses"). My cursory search of bound vs unbound forms reveals several articles that suggest unbound forms are more ideal in a large user environment. What say you?
Have a lovely weekend!
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
On Feb 19, 2016, at 3:11 PM, jennylou68@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I am executing an INSERT INTO statement. I am using unbound forms to force users to consciously decide to add their submission to the database (by clicking a "Save" button). I spent to much time cleaning up records that were not complete because a user realized they were not ready and just closed out the database, leaving the partial information.
I know unbound forms are less than popular with database designers but I haven't learned any other way to do this. I have no formal training in Access so I am constantly trying to learn how to do things. My next quest will be to understand how to use bound forms more effectively.
Have a fantastic day!
Posted by: John Viescas <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (6)|