How to Open Form and Record of a Name Selected from A Listbox?

[number2]

I would like to open a patients file form from a listbox. I have tried several things. The best I can acheive is opening the form with a blank record. Here's my code on the dbl click event of the list box:

Private Sub List45_DblClick(Cancel As Integer)
Dim strCriteria As String
strCriteria = "[QME/AME Information]![lastname]=[Forms]![QME/AME Information]![lastname]"
DoCmd.OpenForm "QME/AME Information", acNormal, , strCriteria
End Sub

 

[braindead2]

the form opens blank because you are not refering to the control properly
need to refer to the value being returned by the listbox
strCriteria = "[QME/AME Information]![lastname]= '" & me.list45.selected.value & "'"

or if the value is in a textbox named lastname
then this should do it

strCriteria = "[QME/AME Information]![lastname]= '" &[Forms]![QME/AME Information]![lastname] &"'"

 

[number2]

Thanks Brain, I am trying that method and not having any luck. The listbox shows the lastnames but will not select the name and move to their record. It still opens to the first record. Any ideas?

 

[gusbrunston]

Hi.
Make sure that you have the form property "Data entry" set to "no." If it's yes you'll never find your records.
Gus Brunston An old PICKer, using Access2000
gustrel@aol.com