View Single Post
  #2 (permalink)  
Old June 21st, 2005, 01:35 PM
Kevinsharrison Kevinsharrison is offline
Registered User
 
Join Date: Apr 2005
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Kevinsharrison
Default

I think this is what you want, this is how I have done this in the past. I use the double click event. Then it will take the data of the bound column. Then i would open another form based on the info. I think that is what you are trying to do.

Private Sub listbox_DblClick(Cancel As Integer)
Dim strlstData As String
Dim strCriteria As String
Dim i

For Each i In lstStnBOAll.ItemsSelected
  strlstData = lstStnBOAll.ItemData(i)
Next

strCriteria = "[Broadcast_Num]= " & strlstData
DoCmd.OpenForm "frmBroadcastorder", , , strCriteria

End Sub

Reply With Quote