How do a specify a name from 50 names in a report - Newbie

[jeridbohmann]

I have a database that has 2 tables. One table is a number (IP Adress) and a
username. The other table has a number (IPAdress - linked to 1st table to get
the username) date, time, web page.
It's basically a internet usage report. The server creates a spreadsheet
with IP Adress, date, time, web page which is imported into the database. I
have 5 reports. Mon, Tues, Weds, etc..
I have about 75 users and the activity is quiet large which gives me a 75
page report. It's all alphabetical, but I still have to scroll through 75
pages.
I would like to be able to use a form and choose the usersname and have it
pull up Mondays report with only their name on it. Right now the report opens
with all 75 people.
Do I have to create a new report? New Query? How would I go about doing
this. It's a small database, but has a lot of information in it.

Thank you in advance....Jerid.

 

[Tom Ross]

Assume your form has a combo box labeled ComboUser
and a button. The code behind the button opens the report and specifies
which user will be displayed.
-------------
Dim strReport, strCriteria As String
strReport = "Your Report Name"

' a Where Clause without the word Where.
strCriteria = "User = '" & Me.comboUser & "'"

DoCmd.OpenReport strReport, , , strCriteria
-----------------

 

[jeridbohmann]

Thank you sir.
This simple database is turning into a full blown project and want all this
stuff I have no clue about.

 

[Tom Ross]

Access has a way of blowing it self into bigger and bigger applications,
Don't Fight it