I am trying to write the code to open a report and set the query behind it with values in two fields. I can do it with one value but I'm not sure how to code the second field and value.
My Attempt: DoCmd.OpenReport "rptReportStudentsSortedByGradYear", acViewPreview, , "[none]=0 and [gradyear]= me.txtGradYear"
The part from and on is what I am not doing correctly I am trying to take a value in a textbox on the form and place it in the [gradyear] field of the query along with a 0 in the [none] field.
Thanks for the help.