Hi all,
I have two tables, let's say A and B. Table A contains a number of Yes/No fields while Table B has text fields that contain various statuses. Tables A and B are linked via the status field.
I also have a form on which I have multiple checkboxes so that a user can select a which Yes/No fields they can filter in order to run a query and generate a report. This works fine for fields in Table A which have the Yes/No fields. However, I am wondering how I would list the text field values as checkboxes so that users can select which values to include in the query, but cannot think how I can overcome the text and Yes/No difference.
I am using the QBE Expression Builder as follows:
Expr1: [FieldinTable]=[Forms]![Navigation Form]![NavigationSubform].[Form]![FieldonForm]=True Or [Forms]![Navigation Form]![NavigationSubform].[Form]![FieldonForm]=False
This works perfectly for the Yes/No fields in Table A, But when I list the statuses as checkboxes, I am not sure how I convert the 'yes' in the checkbox to the relevant status from Table B.
Hopefully this makes sense and any help would be most appreciated.
I have two tables, let's say A and B. Table A contains a number of Yes/No fields while Table B has text fields that contain various statuses. Tables A and B are linked via the status field.
I also have a form on which I have multiple checkboxes so that a user can select a which Yes/No fields they can filter in order to run a query and generate a report. This works fine for fields in Table A which have the Yes/No fields. However, I am wondering how I would list the text field values as checkboxes so that users can select which values to include in the query, but cannot think how I can overcome the text and Yes/No difference.
I am using the QBE Expression Builder as follows:
Expr1: [FieldinTable]=[Forms]![Navigation Form]![NavigationSubform].[Form]![FieldonForm]=True Or [Forms]![Navigation Form]![NavigationSubform].[Form]![FieldonForm]=False
This works perfectly for the Yes/No fields in Table A, But when I list the statuses as checkboxes, I am not sure how I convert the 'yes' in the checkbox to the relevant status from Table B.
Hopefully this makes sense and any help would be most appreciated.