Prompt User for Input to Query

[Guest]

In the Criteria section type in [Student name]

The query will pop up a box the asks for the name, but you
have to match it exactly.

-----Original Message-----
Hello, I am trying to create a Database for a small adult

school that wants to track their students. We need the
ability to do transcripts; keep attendance; etc. I have
most of that already in place. What I would like to do
however, is to find the student's information on demand. I
can easily do that in a query. but let's say the student's
name is Charlie Brown. It is getting close to Charlie's
Graduation. He needs to see if there is any make up work
that he has to do. He goes to the school's administrator.
She click's on "Transcripts". I want Access to prompt the
administrator for the student's name. Can this be done
easily? Any help would be appreciated.

 

[Lynn Trapp]

Put this in the Criteria section and the match doesn't have to be exact.

Like "*" & [Student Name] & "*"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

In the Criteria section type in [Student name]

The query will pop up a box the asks for the name, but you
have to match it exactly.

-----Original Message-----
Hello, I am trying to create a Database for a small adult

school that wants to track their students. We need the
ability to do transcripts; keep attendance; etc. I have
most of that already in place. What I would like to do
however, is to find the student's information on demand. I
can easily do that in a query. but let's say the student's
name is Charlie Brown. It is getting close to Charlie's
Graduation. He needs to see if there is any make up work
that he has to do. He goes to the school's administrator.
She click's on "Transcripts". I want Access to prompt the
administrator for the student's name. Can this be done
easily? Any help would be appreciated.

.