All,

I haven't used Access in awhile and I'm trying to figure our how to write a formula using IIf function to checkmark an associated checkbox if there is a certain value in the table it's sourcing. For example, I have in my report a section for gender with checkboxes for each option. In the table that the report is sourcing, I have a column labeled Gender with an "M" for Male and an "F" for Female. I would like to write a formula that looks in this table field and if an "M", to checkmark the checkbox indicating "Male". I tried this formula associated with the specific checkbox for Male, but it didn't work: =IIf([tblReportables]![Gender]="M",1,0)

Any other ideas on how I can achieve this?

Thanks!
kdestef


*** checkbox.JPG