Open record in main form from subform

[Shredsec.com]

How do I display a record in my main form by clicking on it in my subform? The data is being pulled from the same table.

Tried a GoToRecord macro without success and can't find the answer anywhere.

 

[emorris1000]

Honestly that seems kind of backwards. The normal flow of design would be that the record you select in your main form should open the record in the subform (linked if they are both bound, which makes it super easy.)

But if for whatever reason you have to do it that way, I would suggest that both forms be unbound. The main form would be a query that used the record selection in the subform as its criteria ("like forms.[SubformName].[RecordSelector].value"....can't remember if you need the .value or not). The subform could be bound I guess...

Still though, this is pretty much backwards of what you would normally do and is a bit cludgey.