Students

[Rohit0012]

I am trying to create a report where the report will show the student concerns however what i need the report to do is ask me for the student name first and then for the report to display the concerns of that student.


I have 2 tables students and concern every student in the table has at least 1 concern. any help would be greatly appreciated.
Thanks

[needafix]

As long as your Concerns table contains a student ID you can create a dropbox with all the students on a form - then use the selected student ID to filter the report of concerns. Use the value in the "combobox.value" to get the ID then just apply it when you call the report. Here is a sample of the vba code:

DoCmd.OpenReport "rptSchoolForms", acViewPreview, , "SID = " & cboSchools.Value

Just put this inside a button

[needafix]

Another idea would be to use a parameter query to ask for the student ID and use the query as the source for the report.

[Rohit0012]

Another idea would be to use a parameter query to ask for the student ID and use the query as the source for the report.

Any Chance of what the paramter should say pls

[Rohit0012]

Don't Worry Thanks It works now like a dream

[Rohit0012]

Soz if im bugging but my manager now wants 2 search by tutor and review teacher a quick reply wud be greatly appreciated

[needafix]

I have attached a sample query in the "fourm.mdb".
Here is a page on parameter queries:
http://office.microsoft.com/en-us/access/HA011170771033.aspx?pid=CL100570041033.

[needafix]

Not sure I understand but if you put the parameter on the Tutors Primary Key or name field you should get all the tutor's reviews back. You can sort by teacher to group the reviews if there is more than one per teacher. I believe you can also create more than one parameter on a query.

Also, not good to use numbers instead of words - is it "2 searches" or "to search"? Because of the singular "search" I assumed the latter.

[Rohit0012]

Thanks they all work now i really appreciate this guys