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