Opening a Form

[lorraine]

I have a from which shows details of a client
It contains 2 unique fields ClientId and Account Id. I need to open a new form with details of an order based on these particualar fields. I've tried a form based on a query which will work but only if you input the ClientId and AccountId through a msgbox which the query throws up. Is there anyway of doing this automatically as the field are in both forms

thanks in advance
Lorraine

 

[Martine]

First Excuse my english and i hope you can understand my access terms because i have a french version.

May be you can based your form only on a table and create a buttton and in the event "on click" you can ask to open the new form with the command :
DoCmd.Openform "Formname",,,"["ID=]"&Me.("ID"]
Formname = the name of the form you want to open, ID= the name of the parameter you want to pass to this form.

You can also in your query for the second form put a criteria where you say that your field must = the field of your first form.

I hope that will help.

 

[lorraine]

Thanks Martine, I will give it a try

Lorraine