Alhakeem1977
Registered User.
- Local time
- Today, 15:01
- Joined
- Jun 24, 2017
- Messages
- 308
Hi All,
I am struggling with the below query criteria to return specific Combobox items depends on another text box field called [test].
1. if [test] is = "Case" should returns [StatusID] (4, 11, 12).
2. If [test] is = "Form" should returns [StatusID] (1,2,3,8,9,11,12).
The issue is that the [Status]Combobox does not return anything.
Below is the expression and a screenshot of the Combobox query:
Thank you so much in advance!
I am struggling with the below query criteria to return specific Combobox items depends on another text box field called [test].
1. if [test] is = "Case" should returns [StatusID] (4, 11, 12).
2. If [test] is = "Form" should returns [StatusID] (1,2,3,8,9,11,12).
The issue is that the [Status]Combobox does not return anything.
Below is the expression and a screenshot of the Combobox query:
Code:
IIf([Forms]![Case Details]![test]="Case",Eval([tblStatus].[StatusID]) In (4,11,12), Eval([tblStatus].[StatusID]) In (1,2,3,8,9,11,12))
Thank you so much in advance!