I'm sure there is a way to link two subforms to each other. Here's my problem. I have a main form with "Customer Name" as the main field. Subform 1 is linked by "Customer Name" and is a datasheet that shows all the customers by that name in different locations. Subform 2 should be linked to Subform 1 by Customer ID # - so that, when a user selects a customer name in a particular location, Subform 2 will display order details for this customer automatically.

I looked at the Northwind sample database and they have a form that works very similar to what I want. But, I cannot figure out what they have that I don't have on mine. Subform 2 seems to be linked to the main form and not Subform 1.

Anyone have any ideas?

Thank-you very much.

Easiest way I find is to create a main form out of what you call subform 1, drag subform 2 into it and set links accordingly,drag both into your first form and set link to Customer Name.
HTH.

Thank-you Richie.

That works but I'd like both the subforms to appear in datasheet view. As it is at the moment, I have to make subform 1 in Single Form view in order for both forms to appear in the main form. Any way I can do that?