Custom Report That Shows Only Part Of A Table

[phifer2088]

I am new to access and looking for help. I am using a database to keep track of serial numbers of netbooks that we issue to each student. I have created a form that each student inputs their info (last name, first name, class#, serial number) into when they are issued a netbook and it is stored into a table. Now I want to make it possible for the instructor to select their class number from a list and a report to be created with only students from their class. How would I go about doing this? Thanks in advance.

[June7]

Here is one method http://datapigtechnologies.com/flash...mtoreport.html

[phifer2088]

Here is one method http://datapigtechnologies.com/flash...mtoreport.html

After trying this method when creating the report it asks me for the other parameters on the table. I want it to automatically pull this info if one column matches the criteria.

[June7]

If you get parameter input popups then you haven't followed the demo and/or your parameter references are not correctly referencing the form controls. Post the parameterized query you use as the report RecordSource.

If you want to provide the db for analysis, follow instructions at bottom of my post. Identify objects involved.