[AccessD] Some help please...

Kostas Konstantinidis kost36 at otenet.gr
Mon Nov 22 11:46:38 CST 2004


On a start form I use a list box witch on open responds like:
SELECT MT_basic_char.AM, [Last_name] & " " & [First_name] & " (" & 
[Father_name] & ", " & [year_born] & ")" AS patient
FROM MT_basic_char

I am trying to filter the patients names from a text box like:
Private Sub text_box_Change()
Me![list2].RowSource = "SELECT [Last_Name] FROM [MT_basic_char] WHERE 
[Last_Name] like '" & Me![text_box].Text & "*'"
End Sub

And continue with a double click to open tha main form filtered on:
Private Sub list2_DblClick(Cancel As Integer)
    Dim stDocName As String
    Dim stLinkCriteria As String
        stDocName = "MT_basic_char"
        stLinkCriteria = "[AM] = " & Me!list2.Value & ""
        DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

My question is: on text_box change how it could be possible to apear also 
all data: AM, Last_name, Father_name and year_born
in order to work the double click?

thank's a lot
/ kostas konstantinidis 





More information about the AccessD mailing list