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