469,611 Members | 1,704 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,611 developers. It's quick & easy.

Problems with form based query

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

Apr 25 '06 #1
2 2379
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....

Apr 25 '06 #2
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.

Apr 25 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by TH | last post: by
3 posts views Thread by Reginald | last post: by
3 posts views Thread by Wayne Aprato | last post: by
2 posts views Thread by Jonathan \(Pickles\) Sklan-Willis | last post: by
8 posts views Thread by tess | last post: by
2 posts views Thread by franc sutherland | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.