VBA Help 1

[jalenben1]

I have a text box in my form:

([qryHuaweiTicketsQuery.DateCreated])-([qryHuaweiTicketsQuery.Occurrence-Date]) AS [MTTR Response]

This gives me the MTTR (Mean Time to Respond) which is what I want. I have a combo box with 5 catgories:
SLA Criticality Target
Critical 0:15
Critical (Not Measured) 0:15
Major 0:15
Major (Not Measured) 0:15
Minor 0:35

I want to be able to click on either one of the categories above in a combo box that is linked to the text box that will automatically popoukate if the MTTR of a ticket has MET or MISSED its target

 

[dhookom]

Set the control source to:

=IIf(([DateCreated]-[Occurrence-Date]) < TimeValue(cboCriticality.Column(1)),"MET","MISSED")

Next time, please take the time to provide sample records, actual field and/or control names, and logic. You have been asking enough questions that you should understand how to provide the significant information.

Duane
Hook'D on Access
MS Access MVP