Im a computing student that is a little stuck, im creating a stock control system and want to be able to search a table for a specific product in the product table. the only problem is that i want it to run off of a double click on a list box, this will then open a form that shows all the attributes of that product.

Please help, any ideas will be kewl :) :)


The only way forward is to understand the past

Did you try Recordset object?

The double-click should open the form that's based on the table (or a query based on that table) with a WHERE statement.

Suppose your listbox is called lstMyList and the product field is called strMyProduct and the second form is called frmMyResult. Then in the listbox's double-click event, you'd have something like this:

DoCmd.OpenForm "frmMyResult", , , "[strMyProduct] = '" & Me.lstMyProduct & "'"

The second form will open and will be filtered to only those products.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Oops... typed too fast... here is a correction:

DoCmd.OpenForm "frmMyResult", , , "[strMyProduct] = '" & Me.lstMyList & "'"


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

its worked fine but it is not giving the information that that producte has, the second form has all the information regarding that where abouts of the product, and unfortunately these have to be shown as well.

Thank you :) :)

The only way forward is to understand the past