Hello,
Forum
I need help w/ filtering my cbobox, [Forms]![frmLog]![cboReason] based on [Forms]![frmLog]![Withdraw]
I do not know what will be the best practice.
To use Iif, If or Select Case?
Please help and Merry Christmas
Haziq
Hello,
Forum
I need help w/ filtering my cbobox, [Forms]![frmLog]![cboReason] based on [Forms]![frmLog]![Withdraw]
I do not know what will be the best practice.
To use Iif, If or Select Case?
Please help and Merry Christmas
Haziq
Should be achievable by changing the criteria used in the SQL statement and for the combo box. For more information on this search for cascading combo boxes.
However, the second column of the combo box appears to have three possible values (Out, In and Nil) but the check box can only have one of two values(True or False)
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Hello Bob,
I tried using Yes/No as identifiers (TakeOut) for my Reason And set it as my criteria : Iif([Forms]![frmLog]![Withdraw], TakeOut = True, TakeOut = False).
I dont think my expression is correct. That is the reason why I am getting an error.
Please help
Thanks
Haziq
Dear Bob,
I am sorry to disturb you but I cannot seem to solve my problem.
I was thinking of using VBA after update in Withdraw.
I do not know which filter to apply.
Please help me
Haziq
Try the attached file
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Thanks Bob!