Welcome to WebmasterWorld Guest from 54.234.8.146

Forum Moderators: open

Message Too Old, No Replies

MS Access

Searching and Displaying Records

     

humpingdan

8:48 pm on Jan 30, 2006 (gmt 0)

10+ Year Member



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

11:31 pm on Jan 30, 2006 (gmt 0)

10+ Year Member


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

8:43 am on Jan 31, 2006 (gmt 0)

10+ Year Member



can anyone break this down a little for me?

Graham

12:31 pm on Jan 31, 2006 (gmt 0)

10+ Year Member



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

[databasedev.co.uk...]

Lilliabeth

12:43 pm on Jan 31, 2006 (gmt 0)

10+ Year Member



Built into Access is 'Filter by Form'.

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

Lilliabeth

12:44 pm on Jan 31, 2006 (gmt 0)

10+ Year Member



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

Featured Threads

Hot Threads This Week

Hot Threads This Month