Hi all,
I have a conundrum that's driving me mad!
I have a categories table with 4 categories that are user selectable on the front end form (P, INCR, SP & VUK), I then have 4 tables that define various failure modes applicable to the categories (tables named FailureModeP, FailureModeINCR etc).
We need a solution whereby the user selects a category in the front end form and then based on that category selection the next drop down box on the form (Failure Mode) would have a list of failure modes that correspond to the categories table. i.e. user selects INCR category and only the failure modes in the FailureModeINCR table are available for selection.
My initial thought was to revise the row source SQL statement on the Failure ID Combo Box on the form to incorporate a multiple IF statement however, would it be better to use VBA?
Many thanks for any suggestions.
I have a conundrum that's driving me mad!
I have a categories table with 4 categories that are user selectable on the front end form (P, INCR, SP & VUK), I then have 4 tables that define various failure modes applicable to the categories (tables named FailureModeP, FailureModeINCR etc).
We need a solution whereby the user selects a category in the front end form and then based on that category selection the next drop down box on the form (Failure Mode) would have a list of failure modes that correspond to the categories table. i.e. user selects INCR category and only the failure modes in the FailureModeINCR table are available for selection.
My initial thought was to revise the row source SQL statement on the Failure ID Combo Box on the form to incorporate a multiple IF statement however, would it be better to use VBA?
Many thanks for any suggestions.