Attachment 5760I've inherited an Access database in my new role at work and have been looking to make some improvements to it, but know really nothing at this point about Access. Basically, on this form (please see attached), I need to come up with a way to make the selections in some of the fields dependent on a previous selection.
Just some background, this system collects information and investigation results on failed electronic devices. So what I would like to see is: In the confirmed field, if the user selects Y, only certain options will be available in the Fail Code and Root Cause fields, and make it limit the selections available based on previous selections. I see way too many inconsistencies from users in doing this correctly with all of the selections available in each field.
First, is this possible?? If so, does anyone have any suggestions or even a tutorial I can follow to set this up? Thanks for any help!!