How to filter cbobox based on checkbox

[MdHaziq]

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

[Bob Fitz]

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)

[MdHaziq]

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

[MdHaziq]

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

[Bob Fitz]

Try the attached file

[MdHaziq]

Thanks Bob!