checkboxes in reports 1

[terpster]

Hi!
I'm trying to have check boxes 'checked' or unchecked based off of values in one of my tables.

I have 4 check boxes:
Yes
No
Pending
Information not in file

The values in the table:
1=Yes
2=No
3=Pending
4=Information not in file

How do I get the apprpriate box checked for each customer based on their value in the table?

Hopefully someone will understand what I"m trying to do, Thanks!

 

[humbleprogrammer]

Put the following code in your check boxes Control Source property.

Your Yes checkbox
=IIf([YourFieldName]=1,"Yes&quot

Your No checkbox
=IIf([YourFieldName]=2,"Yes&quot

Your Pending checkbox
=IIf([YourFieldName]=3,"Yes&quot

Your Information not in file checkbox
=IIf([YourFieldName]=4,"Yes&quot

hope this helps.

 

[terpster]

I figured out how to do what I wanted to do.
Is there a way to delete unwanted posts?

Thanks!

 

[terpster]

Thanks humble! I used radio buttons instead, but your post was very helpful (I was in the middle of posting my reply when you must have submitted yours! )