What I expecting was the subform (based on a form linked to parent) would act similarly as a list report.  Where you could click on the row and the actual form would popup with all the fields available for editing the subform information.

However, what it does is all editing of only "shown" fields in the row of the subform, With no way to get to the actual form, that I've found.

I building a contact list.

Parent form is Customer Info (billing address, tax info, ect.)

But, our customers are Schools, which one school can have many contacts (shipping address, phone#, email), so the subform is the contacts for the "Parent" customer.

When an order is to be placed, I envision our sales rep selecting the "customer", then selecting the "contact". Together this would give us all the information needed for the sales order.  They then could proceed with adding products to the sale.

Any Idea on how to achieve this??

Thanks

Mark