Open different forms from list box

[foxtet]

I have issue opening different forms from the contents of list box. is it possible to open different forms by double clicking list box entry..

Need your help

Foxtet

 

[jdraw]

What exactly is in the list box?
What is the end result of this? There may be other options.

 

[brharrii]

I do something similar with my listboxes. This is the code I use on the "on dbl click" event:

    DoCmd.OpenForm "[Form Name]", acNormal, , "[PrimaryKey Field]=" & Me.[Listbox Name].Column(4)

make sure the column number refers to the column in the listbox that will identify the record you wish to edit in the new form.