List Box Double Click

[manny1234]

I have a list box set up in a form. I want to be able to double click an item in the list box and have it open a seperate form with the corresponding record. Here is what I have.

Private Sub List0_DblClick(Cancel As Integer)
DoCmd.OpenForm "MD_ActView", , , "" & Me![VPSID] & " = [ID]"
End Sub

The problem is it pulls the VPSID from the first record and not the record being selected. IE

vpsid     name    somethingelse
123       dude    goes places
321       himom   stays home

If I select 321 it pulls up the record for 123...

 

[hermanlaksko]

DoCmd.OpenForm "MD_ActView", , , [ID]= " & Me!VPSID

Looks like you had them turned around ;-)

Herman
Say no to macros

 

[manny1234]

No beans. Same thing when it is switched up.

Private Sub List0_DblClick(Cancel As Integer)
DoCmd.OpenForm "MD_ActView", , , "[ID] = " & Me![VPSID] & ""
End Sub

 

[manny1234]

heh! here is the working code

Private Sub List0_DblClick(Cancel As Integer)
DoCmd.OpenForm "MD_ActView", , , "[ID] = " & Me![List0] & ""
End Sub

I needed to call the value of the list box not the VPSID for the form...

 

[hermanlaksko]

Practice makes perfect

Herman
Say no to macros

 

[manny1234]

aye