Unanswered: Trouble populating checkbox in report.
Heeeeeeeeeeeeeeelp please! I have a database with 9 tables, of which 4 have 2 fields. The two fields are a unique identifier to relate to the main table and the second is a text field with a drop down menu that has anywhere from 2-4 options. My form populates the tables just fine, the problem is the check boxes in my report do not populate.
I have to modify my 'control source' properties and attempted to write a SQL statement to accomodate this need but no luck. Any help would be GREATLY appreciated.
The first table is [Form Type] and it's fields are [NF ID] and [Nature of Form]. [NF ID] is the primary key and [Nature of Form] is my dropdown menu. My dropdown menu has two 'text' values in it, they are "PCR" and "VERIFICATION.
My problem is that when I populate this table from my form, it does not populate the field in my adjoining report. How can I modify the properties on the report to show a check box to reflect each value. All the other fields from my other tables are populating the report.