Linking Id's through a Macro in Access

[JBros]

I'm trying to make a relation between two tables to show information through a Macro. To give a perspective, I have a table called 'Companies' where there are all the information needed. I've made a 'Home' form where there is a SubForm to show the companies.




My idea is that the field 'Companies' of this subform, which shows the name of the company, could link to another subform called 'Companies Detail' through the ID.
So far, I've done this to the macro (the id field is called Id_company).:
The syntaxis is in spanish so sorry for that and hope this could be understable:

If EsNulo([Formularios]![Consulta para Detalle Empresas]![Id_company])

then do a BIP.

If NoEs EsNulo([Formularios]![Consulta para Detalle Empresas]![Id_company])

then

OpenForm

and in the conditions on

WHERE

I've written:

="[Id]=" & [Id_company]

The idea is that when you click on the name of the company in the Home form, this redirects to the 'Consulta para Detalle Empresas' form. I can't get it working. I'd like to hear opinions and I'll share more information and do my best to make it understandable if it isn't at all. Thank you in advance.

[ranman256]

Normally, you'd open a parent form to show a single record Company rec.:OpenForm "frmCo",,,"[id]=" & me.id
The subForm would be the company detail, linked on the ID field.:
the only code would be to open parent form from the main form.
but,
You have a main form with 2 sub forms. (Sounds busy) but the links are the same,
the subForm Co names, and the subForm CoDetails.
subform Co name would have no link,
subform CoDetail would have a link to subForm Co ID.

[JBros]

Thank you for the reply, I'm gonna check it right now. However, to give you an idea, I'd like to do something like in the Northwind sample database, with a main 'Home' form and links to detail as in the Northwind there are the inventory files.



So I mean those links that link to specific form for each product, in Northwind's example. Thank you again.