Recods from one form in second form

[rici7]

Hello,



can anybody help me with this problem? I have table with customers, form with list of those customers and form with details of customers. I want to create macro which open the customer details form after clicking on customer name in the customer list but with details of customer on which I have clicked.

[rpeare]

Is there a reason you want a different form to open with the customer details instead of using a form/subform arrangment?

[rici7]

The reason is that first form is just list with customer name and address but in the form customers details is more informations from another table.

[rpeare]

That's exactly what a form/subform is intended to help with. If your second table has the customerID unique key field stored in it you can make a form/subform where all the information on the second table is displayed on the same form with the customer and you can look at all the records without having to use a second form.

[rici7]

Yes but my problem is that I need in each forms different data. But if I use form/subform, I can choose only same fields for booth forms.

[rpeare]

I don't understand. Perhaps if you attached a copy of your database with sample data in it instead of real data it might be more helpful.