restrict data in combo box

[newkid]

I have a combo box that lists returns. The returns can be open or
closed. I want the user to be able to restrict the data in the combo
box if they check the [ckOpen] check box. I've tried several ways but
none of them work. Any help would be appreciated.

Combo box query:
SELECT tReturns.MerchandiseReturnNo, tReturns.VendorName,
tReturns.VendorID, tReturns.Description, tReturns.ReturnDate,
tReturns.COGAccountNo, tReturns.ReturnAmount, tReturns.Status,
tReturns.CompanyID, tReturns.MerchandiseReturnNo, IIf([Forms]!
[fReturns]![ckOpen]=True,[Status]="Open","*") AS ReturnOpen
FROM tReturns
ORDER BY tReturns.VendorID, tReturns.MerchandiseReturnNo;

Thanks

 

[omocaig via AccessMonster.com]

if I am understanding the issue correctly then you need to move your iif to
the where clause:

WHERE [Status] like IIf([Forms]![fReturns]![ckOpen]=True"Open","*")

hth,
Giacomo

I have a combo box that lists returns. The returns can be open or
closed. I want the user to be able to restrict the data in the combo
box if they check the [ckOpen] check box. I've tried several ways but
none of them work. Any help would be appreciated.

Combo box query:
SELECT tReturns.MerchandiseReturnNo, tReturns.VendorName,
tReturns.VendorID, tReturns.Description, tReturns.ReturnDate,
tReturns.COGAccountNo, tReturns.ReturnAmount, tReturns.Status,
tReturns.CompanyID, tReturns.MerchandiseReturnNo, IIf([Forms]!
[fReturns]![ckOpen]=True,[Status]="Open","*") AS ReturnOpen
FROM tReturns
ORDER BY tReturns.VendorID, tReturns.MerchandiseReturnNo;

Thanks

 

[newkid]

if I am understanding the issue correctly then you need to move your iif to
the where clause:

WHERE [Status] like IIf([Forms]![fReturns]![ckOpen]=True"Open","*")

hth,
Giacomo

I have a combo box that lists returns. The returns can be open or
closed. I want the user to be able torestrictthe data in the combo
box if they check the [ckOpen] check box. I've tried several ways but
none of them work. Any help would be appreciated.

Combo box query:
SELECT tReturns.MerchandiseReturnNo, tReturns.VendorName,
tReturns.VendorID, tReturns.Description, tReturns.ReturnDate,
tReturns.COGAccountNo, tReturns.ReturnAmount, tReturns.Status,
tReturns.CompanyID, tReturns.MerchandiseReturnNo, IIf([Forms]!
[fReturns]![ckOpen]=True,[Status]="Open","*") AS ReturnOpen
FROM tReturns
ORDER BY tReturns.VendorID, tReturns.MerchandiseReturnNo;

Thanks

Worked like a charm. Thanks so much!