Hi,
I have 2 Combos boxes on a form named CboMainCriteria and CboCriteriaDetails.
Combo CboMainCriteria is based on T_Violations tbl wherein 3 field called ‘Crietria’ , ‘Reason’ and ‘Justification’. Whereas second combo CboCriteriaDetails is based on table tbl T_Violations
T_Violations containes many criteria such as LATES, ABSENT Etc…. and each criteria has different reasons…> 15 min, > 30 Min….and so on… as follows.
LATES >15 Min
LATES > 30 Min
LATES More than 2 hrs.
ABSENT
ABSENT
ABSENT
CboCriteriaDetails rowsource data is based on CboMainCriteria and are working well using Me!CboCriteriaDetails.RowSource = Me!CboCriteriaDetails.RowSource line in After Update event of CboMainCriteria.
At present when I am updating data in CboMainCriteria , my second combo CboCriteriaDetails is generating correct relevant values.…which is fine.
What I am looking for is : I have 3rd combo called “CboStartSent” which is based on other table called “T_WarnSent” wherein “Criteria” & “Reason” are same fields as mentioned in T_Violations
BUT Please note CboStartSent record source is different tbl “T_WarnSent” wherein “Criteria” is same field as mentioned in tbl “T_Violations”
I want my third combo “CboStartSent” to display only those records that is relevant with my second combo “CboCriteriaDetails”
This is not happening because for third Combo I used another table as said.
So how can I do that? Any help shall be appreciated.
I have 2 Combos boxes on a form named CboMainCriteria and CboCriteriaDetails.
Combo CboMainCriteria is based on T_Violations tbl wherein 3 field called ‘Crietria’ , ‘Reason’ and ‘Justification’. Whereas second combo CboCriteriaDetails is based on table tbl T_Violations
T_Violations containes many criteria such as LATES, ABSENT Etc…. and each criteria has different reasons…> 15 min, > 30 Min….and so on… as follows.
LATES >15 Min
LATES > 30 Min
LATES More than 2 hrs.
ABSENT
ABSENT
ABSENT
CboCriteriaDetails rowsource data is based on CboMainCriteria and are working well using Me!CboCriteriaDetails.RowSource = Me!CboCriteriaDetails.RowSource line in After Update event of CboMainCriteria.
At present when I am updating data in CboMainCriteria , my second combo CboCriteriaDetails is generating correct relevant values.…which is fine.
What I am looking for is : I have 3rd combo called “CboStartSent” which is based on other table called “T_WarnSent” wherein “Criteria” & “Reason” are same fields as mentioned in T_Violations
BUT Please note CboStartSent record source is different tbl “T_WarnSent” wherein “Criteria” is same field as mentioned in tbl “T_Violations”
I want my third combo “CboStartSent” to display only those records that is relevant with my second combo “CboCriteriaDetails”
This is not happening because for third Combo I used another table as said.
So how can I do that? Any help shall be appreciated.