Reverse Form/SubForm Parent/Child relationship

[Pete]

I'm trying to build a form which is control by a subform in datasheet view. Basically, I want the subform to display all the data from a query/table and, when a record is selected, I'd like all the related data from other tables to appear on the rest of the form (and two additional subforms)

The principle is that I have a list of clients who each have separate Invoice and Service details, I want to be able to quickly scan the client list (in Datasheet view so that it can be sorted etc...) and then review the details of their Invoice and Services (but also details regarding their input and feedback - through subforms)

Can anyone help? I've checked books and numerous websites but haven't turned anything up..

Thanks.

 

[Van T. Dinh]

The normal set up is to have the Clients as the RecordSource for the
Mainform with a ComboBox or ListBox for the user to select a particular
Client. When a Client is selected, the Client becomes the Current Record on
the Mainform and the rest will follow if you use linked Subforms.

Note that linked Subforms are designed for Tables in One-to-Many
relationship where the Mainform is bound to the "One" Table and the Subform
to the "Many" Table. Your arrangement seems to be the reverse of the
intended purpose of the Subforms.

My guess is that you can use unlinked Subform if you want to do it this way
but you will have to write VBA to do the Record navigation on the Mainform.

--
HTH
Van T. Dinh
MVP (Access)

I'm trying to build a form which is control by a subform in datasheet

view. Basically, I want the subform to display all the data from a
query/table and, when a record is selected, I'd like all the related data
from other tables to appear on the rest of the form (and two additional
subforms).

The principle is that I have a list of clients who each have separate

Invoice and Service details, I want to be able to quickly scan the client
list (in Datasheet view so that it can be sorted etc...) and then review the
details of their Invoice and Services (but also details regarding their
input and feedback - through subforms).