Hi:
I'm new to Access, so please let me know if I veer away from acceptable decorum, as I have seen some warnings to others.
I am developing a database that deals with root cause analysis in a manufacturing environment. One crucial part of this is the "5 why" questions. Since this is not limited to five "whys" I wanted to give the user the option of putting unlimited whys. Therefore, instead of making a table with five why columns, I made a table with one why column that connects the whys with an RCA number. The table's name is Initial_Root_Cause_Analysis_Detection.
What I'm struggling with seems simple, but it has been an incredible headache and I have not found an answer in my research. I have a form, (Initial_Root_Cause_Analysis_Detection), to add records which defaults the RCA number to an open and hidden form the user fills out before opening the why form. Above the data entry I have an unbound text box with the default "=Max([Initial_Root_Cause_Analysis_Why_Detection].[Why])". What I need this box to do is update when I click the "Add Why" button, so that the user can see their last "why" when entering the new data. In my expression builder I have the button save, refresh and requery the text box before adding a new record. The text box does not update to show the "why" that was just added. How would I go about updating the text box each time a record is added?
Thank you in advance for any help.
I'm new to Access, so please let me know if I veer away from acceptable decorum, as I have seen some warnings to others.
I am developing a database that deals with root cause analysis in a manufacturing environment. One crucial part of this is the "5 why" questions. Since this is not limited to five "whys" I wanted to give the user the option of putting unlimited whys. Therefore, instead of making a table with five why columns, I made a table with one why column that connects the whys with an RCA number. The table's name is Initial_Root_Cause_Analysis_Detection.
What I'm struggling with seems simple, but it has been an incredible headache and I have not found an answer in my research. I have a form, (Initial_Root_Cause_Analysis_Detection), to add records which defaults the RCA number to an open and hidden form the user fills out before opening the why form. Above the data entry I have an unbound text box with the default "=Max([Initial_Root_Cause_Analysis_Why_Detection].[Why])". What I need this box to do is update when I click the "Add Why" button, so that the user can see their last "why" when entering the new data. In my expression builder I have the button save, refresh and requery the text box before adding a new record. The text box does not update to show the "why" that was just added. How would I go about updating the text box each time a record is added?
Thank you in advance for any help.
Last edited by a moderator:
