Creating Pop Up Form 1

[1318]

I create a Subform inside of my Form that contain various hardware name for each product ( by Item_code).
Can anyone help me how if I click a row that contain a hardware name in the Subform, it's shows up a pop form to show which product is using that hardware.

I am not an expert in access, And I am still practice to create my own database.

Thanks.

 

[Sadukar]

I dont understand exactly what you are looking for.
I think this is it though.

Presuming you are assigning a product to Hardware on a temp basis.

You could create a field in your Hardware record that contains a product code. Place a button that opens another form containing Product details. In the Form_Load of the form opened by the button set-up a filter so it only displys the product Code selected in the subform.
IE
Private Sub Form_Load()
Me.Form.Filter = "[ProductID] = subform field"
Me.Form.FilterOn = True
End Sub

Is this what you are looking for?

 

[2ShotLatte]

If I get what you're saying, you want to double click on a row in a subform to pull up information. I've use this on the "On Double Click" event.

Private Sub Form_DblClick(Cancel As Integer)
DoCmd.OpenForm "Form_Name_tpen", , , "[Key_ID]=forms!Form_Name!Key_ID"
End Sub

I hope this helps.
-steve

 

[judgehopkins]

These might give you additional ideas:

thread702-585184

thread702-580020

"The potentialities of a language are so vast that we must wonder sometimes at ourselves: how do we manage to know so much?" Anthony Burgess, A Mouthful of Air

 

[1318]

Thanks,

I am just trying the Event DblClick from Steve, and it's works.
For Sadukar and JudgeHopkins, thanks for your respons.

 

[judgehopkins]

1318, give Steve a star!

"The potentialities of a language are so vast that we must wonder sometimes at ourselves: how do we manage to know so much?" Anthony Burgess, A Mouthful of Air

 

[2ShotLatte]

Glad it worked. Good luck with the rest of your project.