Open a form in the record that I Want

[AndyEduardo]

Thanks for your attention:

I have one form named Costumers, it has many cards (I don't know wha
is the appropiate word because I am spanish speaker), (when you clic
one card the others hide behind the first)
There are some information about the costumers in each card. Fo
example Products by Agreement is the 2nd card.
When I open the form Invoice, I select the costumer, then in th
subform Details of the Invoice I have the choice to select just th
products by agreement related to this client.

I want this, when I click a cmdbutton (in the form Invoice), it open
the form Costumers in the record related to the costumer showed in th
form Invoice, in the 2nd card, to add a new product....

I appraise your help

 

[Sebastian Helm]

By "card", do you mean the tab controls, which are called "pages" in English
Access? What's the spanish name?

Not sure how you can display the correct record (in fact, I just asked a
similar question ("Simple Form question: How to update, not append"), but if
you want to open page X you can just write in the Form_Load sub the line:
PageX.SetFocus.

Hope this helps,
Sebastian