Record Number retrieval

[atrottier]

I have a subform that displays items that are part of a component breakdown of the item that is currently displayed on the main form. My user would like to be able to double click on an item in the subform and have the main form then populate with that items information. So the question is: Is there any way to retrieve the record number of the item in the subform so I could use the GoToRecord function? Thanks in advance.

[DarrenOxley]

Use the CurrentRecord function.

for example

Private Sub Form_DblClick(Cancel As Integer)

MsgBox CurrentRecord

End Sub

[atrottier]

Thanks for the reply. It works but the returning record number is the wrong one I am looking for. I'am new to this and I didn't realize that each form and subform when retrieved establish their own record numbers for all the items on their respected form. The record number I want is the one that the selected item from the subform has on the main form (all items on the subform are part of the listing on the main form). I can't imagine there is anyway to find that out without physically using the arrows on the bottom of the main form until I find the item and the record number is then shown.