List Box

[imright]

OK, I'm going to try again and hopefully explain it better this time.
I've created a database to create reports to track problems that happen within the company, each report is numbered in sequence. The report gets the data from a query so I've created a command button where I can input the report number to review or revise the form where I do the input. I've also created a list box that show all the report numbers. What I'm trying to do is bind those report numbers to the form so that I can click on the number to open the form to revise if needed.
I hope that this made sense but the bottom line is I want to bind the list box report numbers so that I can open an individual report.

 

[wazz]

you can use the listbox almost the same way as a command button or combobox. if your command button is working, i guess it's rigged so that the form goes to the record number you entered somewhere. the listbox would be the same, but you click the listbox and use the afterupdate event: go to the record that matches the item you clicked in the listbox. somthing like this:

listbox_afterupdate
me.recordset.findfirst "problemId = " & me.listbox
where the far-left column in the listbox is the record you go to, hopefully an id field.

hth. tired. bb.

 

[imright]

Tried that but got a Compile Error: "Method or Data member not found" and then .listbox was highlighted (& me.listbox)

 

[missinglinq]

Is listbox the name of your listbox? If not, you have to replace it with the actual name of yours.