I have a table in Access as follows:
SLA Criticality Reponse Time Restoral Time
Critical 0:15 4:00
Critical (Not Measured) 0:15 4:00
Major 0:15 8:00
Major (Not Measured) 0:15 8:00
Minor 0:35 12:00
In this table I have 5 categories and the targeted Response Time and Restoral Time. I want to make that into a combo box in a form. Next I want to have a form utilizing the combo box. I already have a text box in my form that I want to be able to automated if a ticket was MEt or MISSED. I have a text box with the MTTR already calculated. Based off the table above how would I create a combo box and then formulate the combo box with the Text box to automate if ticket was MET or MISSED. For example in the combo box if I clicked on any of the SLA Criticality the text box will popoulate if a ticket was Met or Missed.
SLA Criticality Reponse Time Restoral Time
Critical 0:15 4:00
Critical (Not Measured) 0:15 4:00
Major 0:15 8:00
Major (Not Measured) 0:15 8:00
Minor 0:35 12:00
In this table I have 5 categories and the targeted Response Time and Restoral Time. I want to make that into a combo box in a form. Next I want to have a form utilizing the combo box. I already have a text box in my form that I want to be able to automated if a ticket was MEt or MISSED. I have a text box with the MTTR already calculated. Based off the table above how would I create a combo box and then formulate the combo box with the Text box to automate if ticket was MET or MISSED. For example in the combo box if I clicked on any of the SLA Criticality the text box will popoulate if a ticket was Met or Missed.
