Selected Item in Subform Datasheet

[Tommy408]

How can I get the selected item in a datasheet of a subform?

I've tried:

DoCmd.OpenForm "Contacts", , , "[ID] = [Forms]![Search Customers]![Search Customers Subform]![SubformControlName]", acFormEdit, acWindowNormal

 

[VicRauch]

DoCmd.OpenForm "Contacts", , , "[ID] =[red] " & [/red][Forms]![Search Customers]![Search Customers Subform]![Red]Form.[/red][SubformControlName], acFormEdit, acWindowNormal

 

[Tommy408]

It doesn't work.
I probably wasn't clear. The datasheet is on a Form B. And Form A contain Form B as a subform. I need to get the ID of the selected item on the datasheet.

 

[Zion7]

Vic's I believe you reversed your bang & dot?
"[ID] = " & [Forms]![Search Customers]![Search Customers Subform]Form![SubformControlName
Where are you calling your code from, we're assuming Form A,
which is the Parent Form?

Me![Search Customers Subform].Form!pkID, should give you the current
record, on the sub form, no matter what method or action
you use it with.

Dim intID as Integer

intID = Me.sfrmWhatever.Form!pkID

 

[VicRauch]

I guess I should not answer things when I'm in a hurry. Bang and dot are reversed. Thanks Zion!

 

[Tommy408]

That works. Thank you.