homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

MS Access
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
End Sub


 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.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved