Hello,
I'm sure this is a rather simply syntax issue but it is driving me crazy.
I have a continuous form that is bound to a table (class information). I have created a temporary yes/no field in that table. What I want to be able to do is select multiple rows from the continuous form and run a query on those fields. What I have done is used an expr: [Forms]![myFormName]![Checkbox] and set the criteria to -1, then set the criteria for the primary key to the Form Textbox that.
This seems to work but limits the values in the query to the last box checked on the continuous form.
All I want to do is allow people to select multiple rows (with a checkbox) then when a button is pressed a select query is run and only the rows with a checked box are returned. I will then use the results of the query to export the data to Excel and then Email it. I know how to do the last two parts, but the initial query is not working as I intend it to. Thank you.