[AccessD] Some help please...

Guys,
I have just found the solution...
The problem fixed

Thank's

----- Original Message ----- 
From: "Kostas Konstantinidis" <kost36 at otenet.gr>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, November 22, 2004 7:46 PM
Subject: [AccessD] Some help please...


> 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
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>