Kostas Konstantinidis
kost36 at otenet.gr
Tue Jun 29 08:58:44 CDT 2004
Hi all, I am trying to open a form based on a list box criteria with a double click. the list box is linked to a table: SELECT MT_basic_char.AM FROM MT_basic_char; What I want to do is on doulble click to open the main form MT_basic_char based on the line's AM I double click I use the follown but it always just open the first record and not the filter one I have chosen via double click Private Sub list2_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "MT_basic_char" DoCmd.OpenForm stDocName, , , stLinkCriteria stLinkCriteria = Me!list2 = Forms!mt_basic_char!AM End Sub Is that possible? Thanks kostas