MS Access

Searching and Displaying Records

[humpingdan]

I have a database of assesment data, i need to be able to search for individual pupils based on a number of seperate criteria, Name, ID, Surname, Grade, etc,

the problem i have is displaying the multiple records,

say for instance i have three pupils with the surname smith, i need to be able to search for smith in a form and display the three smiths, then double click the particular smith i need by comparing the ID;s of the three smiths and launching a form which displays the relevant data on the pupil.

Can anyone help me achieve this?

[Durham_e]

Create form with student table:

Create list box (list0 below)

Criteria in student name field of list0

Like "*" & [Enter Venue Name] & "*"

In double click event of list0

Private Sub List0_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "individual_student_form"

stLinkCriteria = "[student_id]=" & Me![List0]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

[humpingdan]

can anyone break this down a little for me?

[Graham]

This article shows how to create a list box to help search for records in the database:

[databasedev.co.uk...]

[Lilliabeth]

Built into Access is 'Filter by Form'.

If this would solve your need, it would save you from doing any work.

[Lilliabeth]

Sorry, I'll bet the part I missed is that you want to see all 3 Smiths on screen at the same time. Sorry.