[AccessD] Some help please...

Kostas,

If I understand correctly...you want to display other information besides 
the name for the user to make their choice from.  If you are using a combo 
box, you could include a PK in the select statement, indicate this as the 
'bound column' on the properties of the combo box, hide this field with the 
'column widths' property, and then use this field to filter the main form.

Hope this helps.

Thanks,

Mark A. Matte

>From: "Kostas Konstantinidis" <kost36 at otenet.gr>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: [AccessD] Some help please...
>Date: Mon, 22 Nov 2004 19:46:38 +0200
>
>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