Query combobox question

[BerkshireGuy]

I have a user table with a True/False field called IC.

I have a form - which is "Yes" / "No".

If the user selects Yes on the form, I want only those ICs records
that are True.

If they select No. I want all IC records, regardless of True or False

I tried something like:

((IIf([Forms]![frmUnderwriterAssignmentSystem]![cboInnerCircle]="Yes",
[InnerCircle]=True,True))=True));

but obviously that doesnt work :)

Thanks,
Brian

[ARC]

Seems like "Yes" would be a literal since it's in quotes. You might try
-1 instead of the "Yes"

Another way would be to use the form's filter property. Something like this
in the after update prop of the yes/no field:

If me!cboInnerCircle = -1 then
me.filter = "InnerCircle = -1"
me.filteron = true
else
me.filteron = false
endif


"BerkshireGuy" <be*************************@yahoo.comwrote in message
news:11**********************@z24g2000prh.googlegr oups.com...

>I have a user table with a True/False field called IC.

I have a form - which is "Yes" / "No".

If the user selects Yes on the form, I want only those ICs records
that are True.

If they select No. I want all IC records, regardless of True or False

I tried something like:

((IIf([Forms]![frmUnderwriterAssignmentSystem]![cboInnerCircle]="Yes",
[InnerCircle]=True,True))=True));

but obviously that doesnt work :)

Thanks,
Brian