List Box and Subform

[jboomer]

A list box that displays all the records for a particular student. There is a subform on the page as well that has detailed information.

The List box source is:

SELECT [Record Review].[Record Review ID], [Record Review].[Record Review Item] FROM [Record Review] WHERE [Record Review].[Student ID]=[Students].[Student ID];

And i want the the subform to display the record i select in the list box. The subform displays the appropiate records and i can scroll through andd find the record.

trying to build a macro for "On Click"

please help.

 

[Alisa]

You could just add WHERE RecordReviewID=Forms!YourMainForm!YourListBox to the recordsource of your subform, and then in the on click event of the list box requery the subform. Then your subform will always only show what is selected in your list box. This will only work for a single select list box though.