Hello,
I'm wondering if anyone can help me with the following issue:
I've based some forms on some queries.
Some of the forms are based on queries that are straight forward, returning all records in the query results.
Other queries are based on "IIF" statements and only return the results that are based in the "IIF" statements.
The results in both types of queries also return check boxes, as part of the record information. These check boxes are used to input filtering information for the next steps in the process.
Here's the problem:
The straight forward queries return the information requested, as well as the check boxes. These check boxes function normally and can be used to designate True/False values. Which is exactly what I want them all to do.
However, the check boxes that are contained within the results of the queries that are based on "IIF" statements, will not allow you to enter a True/ False value into the check boxes, after the query is ran.
Can someone please tell me why this is and how to resolve it? I need to be able to enter a True/False value into the check boxes that are returned as a result of a query that has used an "IIF" statement.
Please note that the table that contains the check boxes will allow the boxes to be modified and the queries that do not utilize "IIF" statements do the same. The boxes are only not functioning, after they are returned using a query that contains "IIF" statements.
Any help you can give me will be greatly appreciated.
Thank you!
I'm wondering if anyone can help me with the following issue:
I've based some forms on some queries.
Some of the forms are based on queries that are straight forward, returning all records in the query results.
Other queries are based on "IIF" statements and only return the results that are based in the "IIF" statements.
The results in both types of queries also return check boxes, as part of the record information. These check boxes are used to input filtering information for the next steps in the process.
Here's the problem:
The straight forward queries return the information requested, as well as the check boxes. These check boxes function normally and can be used to designate True/False values. Which is exactly what I want them all to do.
However, the check boxes that are contained within the results of the queries that are based on "IIF" statements, will not allow you to enter a True/ False value into the check boxes, after the query is ran.
Can someone please tell me why this is and how to resolve it? I need to be able to enter a True/False value into the check boxes that are returned as a result of a query that has used an "IIF" statement.
Please note that the table that contains the check boxes will allow the boxes to be modified and the queries that do not utilize "IIF" statements do the same. The boxes are only not functioning, after they are returned using a query that contains "IIF" statements.
Any help you can give me will be greatly appreciated.
Thank you!