Problems with form based query

[cwhite]

I'm having problems with a form based query

The user makes a selection from a drop box, there are only two choices:

Current
Former
the user makes a choice and clicks the preview report button and it
runs the query into the form and nothing appears
the query looks like:
WHERE (tblStudentInformation.SubmittedID=Yes) AND
(tblStudentInformation.Status LIKE (forms![frmNewReport]![Status]))

if I change (forms![frmNewReport]![Status]) to read "Current" then it
returns the correct records, there must be a problem with the way I am
writing the section where it gets input from the form and I can't seem
to figure out the solution.

I wish that I knew what I was doing wrong, because if I just run the
query on its own I don't even get a pop up window asking for the
required data. What did I do wrong?

Thanks

[cwhite]

I think I figured it out, it seems that if I write it as:
((tblStudentInformation.Status)=[forms]![frmNewReport]![Status])) the
query will ask me for information now, now all that I have to do is get
the form to pass the information to the query etc....

[manningfan]

If you're passing this info to a query, just go into Design View and
set the criteria of the field "Status" to
"[forms]![frmNewReport]![Status]" (without the quotes). That's the
easiest way to do it.