How to make a subform open with a control button to a new window

[dkace]

Hi people!
You will soon notice that I am a novice in access so I want your tolerance.
I am building a DB for a lawyer that he doesn't want to have in the basic form of his client the financial data. I have built a form - not with the wizard- and I have to insert this subform also.
The wizard is building this application very easilly but I can't understand how.
Can you help me?
Here are the specification:
-I am in the main form in customer with ClientID=1 (ie)
-I want to view his financial status regarding the company. I want to do it by pressing a button.
-I want this button to open the data only from the specific client.
-I want to be able to process this data.
-I want to enter a last processing date in the form.
-I want to save and exit.

You may say that this is easy to do with macros, but I am sure I had amistake there and couldn't work.

Anyone haveing a solution on this?
Thanks in advance guys ( and girls),
D.

 

[aleb]

Hmm sounds like you do not want to see the subform ( client finstat ) unless you click the button. Well base you subform on the query and in the criterion for the clientid field put Forms!Yourmainformname.[Clientid], place a button on the main form to open a subform. Oh ... just in case if you are going to add new records : in fkey of subform set a default value property to Forms!Yourmainformname.[Clientid] as well.
Now click, process, close.

 

[dkace]

Thanks tovarits. I 'll come back with some more later.