Find tickets

[sdkramer]

Ok. I have a form that has a listbox with a number of items in it depending on the search criteria. I would like if a user double clicks the item in the list box for it to open another form that contains the data for that ticket

eg.

list box says

ID Name Date Problem
2 Seth 4/7/03 Can't get email
3 Doug 4/5/03 Phone won't work

if they double click the line that has ID Number 2 it will bring up the ticket form to that particular ticket

Any ideas?

Seth

 

[soundsfishy]

Place this code in the double click

DoCmd.Openform "YourfrmToOpen", acNormal, , "[ID] = " & ListBoxName.Column(0)
Me![ListBoxName] = ""
DoCmd.Close acForm, "TheformThatHoldtheListBox"


Use the same code on one of my list boxes to open a specific record via a list box.