help! plz

[D.DOC]

I am currently creating a database system that is created in a form within that form there is a sub form with a list of products, and i am wanting to double click a product and automatically display that product and any other product's i double click to be displayed within another sub form.


i have already looked at northwind and ther is no help within that access database for what i am looking for


any help would be most apreceated

 

[wcrc]

you might want to add a YES/NO field to your main table. Then use a comand button to run a query on the subform that looks for items with Yes in that field.

 

[jfgambit]

Assuming you are using a listbox for the ProductID and the bound column is the ProductID then you need to create a ProductID detail form. Then add the following to the On Duoble Click event of the Listbox:

DoCmd.OpenForm "ProductDetail", , , "[ProductID] =" & Me.ProductListbox

HTH