Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
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?
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