newbie help plz double click

[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.

any help would be most apreceated

 

[emcf]

...try having a look at the Northwind database that MS supplies with access. I think the products form may have what you require.

 

[D.DOC]

i have looked at the nortwind and there is no double click event in it

what i am wanting is to double click a row/cell and all information on that row is then displayed in an already open subform

 

[jeremie_ingram]

So what you are wanting is the data within the cell of the first subform to act like a HYPERLINK that would populate the second subform?

 

[Dgar007]

I have a subform that I double click and it populates the major form. May this will help.

I place it in the double click sub within my form:
'CHECKS TO MAKE SURE I HAVE A NUMBER
If Not IsNull(Me.LinkedSFTWNO) Then
'USES FILTER ON PRIMARY KEY USING THE FOREIGN KEY ON THE SUBFORM
Forms!frmApplicationinfonew.Filter = "SFTWNO = '" & Me.LinkedSFTWNO & "'"
'TURNS FILTER ON
Forms!frmApplicationinfonew.FilterOn = True
End if

The filter is what I use to populate the Major Form to begin with.