Searching and Displaying Records
| 8:48 pm on Jan 30, 2006 (gmt 0)|
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?
| 11:31 pm on Jan 30, 2006 (gmt 0)|
|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
| 8:43 am on Jan 31, 2006 (gmt 0)|
can anyone break this down a little for me?
| 12:31 pm on Jan 31, 2006 (gmt 0)|
This article shows how to create a list box to help search for records in the database:
| 12:43 pm on Jan 31, 2006 (gmt 0)|
Built into Access is 'Filter by Form'.
If this would solve your need, it would save you from doing any work.
| 12:44 pm on Jan 31, 2006 (gmt 0)|
Sorry, I'll bet the part I missed is that you want to see all 3 Smiths on screen at the same time. Sorry.