Hi everybody, I have a combobox cmbTran in FormA that displays the values
TranID Name
1 A
2 B
3 C
cmbTran hides the TranID
I want to read the value selected in cmbTran combo box to use it as Criteria in a query for another combobox in the same FormA, i tried to use this criteria:
IIf([Forms]![FormA]![cmbTran] = 1,"LocationX","LocationY")
I believe that the value in cmbTran should be the TranID selected. I do not know what is wrong with my Criteria, thank you for the help =)
TranID Name
1 A
2 B
3 C
cmbTran hides the TranID
I want to read the value selected in cmbTran combo box to use it as Criteria in a query for another combobox in the same FormA, i tried to use this criteria:
IIf([Forms]![FormA]![cmbTran] = 1,"LocationX","LocationY")
I believe that the value in cmbTran should be the TranID selected. I do not know what is wrong with my Criteria, thank you for the help =)