Hey all,
I've been revising an Access 2007 database, which is a series of 15 small forms, so everything runs off of a custom form which I've designated as a switchboard. From the main switchboard, there are two sub-switchboards: one to add data, and one to edit data. (We don't want people to edit their data until they are done with adding data to their form.)
On each switchboard form, there are buttons that go to each of the individual forms. Each individual form has been normalized (to the best of my ability), and uses as a foreign key the "FormID", which means that there is potential for a query that can "join" all the results of the tables, if it is deemed necessary. (The primary key tends to be an autonumber field in each form's table that's hidden from the user, which keeps individual entries distinct.) Each form control's ControlSource are fields within its own table (for a hypothetical example, "frm1" joins to "tbl1").
Each individual data form has a button that allows it to go back to its switchboard. (I was trying to find out in a previous post if you could change the behavior of a button depending on the mode the form is in (either "add" or "edit"), so depending on if a new record is being entered into the database or not, the button could route back to the appropriate subform. I have not implemented this change yet.)
The trouble is, with all the sub-form buttons that we have, I'd like to make sure that once a user is done adding data into each form, the user cannot go back and "add" data into that particular form. I don't want to allow the user to click a button until it is that button's "turn" in being clicked.
I have experience with Enabling buttons and controls with VBA. but I can't wrap my head around slowly "enabling" buttons for the user to go through (thereby moderating workflow). Therefore, I'm eliciting suggestions from the Access folks on this forum.
Does anyone have suggestions on what to do for this matter? Thank you in advance!
I've been revising an Access 2007 database, which is a series of 15 small forms, so everything runs off of a custom form which I've designated as a switchboard. From the main switchboard, there are two sub-switchboards: one to add data, and one to edit data. (We don't want people to edit their data until they are done with adding data to their form.)
On each switchboard form, there are buttons that go to each of the individual forms. Each individual form has been normalized (to the best of my ability), and uses as a foreign key the "FormID", which means that there is potential for a query that can "join" all the results of the tables, if it is deemed necessary. (The primary key tends to be an autonumber field in each form's table that's hidden from the user, which keeps individual entries distinct.) Each form control's ControlSource are fields within its own table (for a hypothetical example, "frm1" joins to "tbl1").
Each individual data form has a button that allows it to go back to its switchboard. (I was trying to find out in a previous post if you could change the behavior of a button depending on the mode the form is in (either "add" or "edit"), so depending on if a new record is being entered into the database or not, the button could route back to the appropriate subform. I have not implemented this change yet.)
The trouble is, with all the sub-form buttons that we have, I'd like to make sure that once a user is done adding data into each form, the user cannot go back and "add" data into that particular form. I don't want to allow the user to click a button until it is that button's "turn" in being clicked.
I have experience with Enabling buttons and controls with VBA. but I can't wrap my head around slowly "enabling" buttons for the user to go through (thereby moderating workflow). Therefore, I'm eliciting suggestions from the Access folks on this forum.
Does anyone have suggestions on what to do for this matter? Thank you in advance!