master detail?

[bensmeets]

hi guys,

I was wondering if it was possible with access to create a master detail form. e.g :

We have a table people. I want to have a list of all the people in the top part of the form and the details of the select person in the bottom of the field.

Is this possible in an easy way with access?

 

[Mile-O]

You can use subforms to do this.

 

[RobJ]

Take a Combo box on top with the names of the people and under the combo box you make fields for the details.

Combo box rowsource = SELECT [field with names] FROM [table with names]
For the other (detail) fields you can make a query. with in the names field the criteria [Form]![name form]![name combo box]

RobJ

 

[bensmeets]

okay, think i am getting it. The combo box should work, but i would rather have a view of more then 1 person. So in that case it should be a subform (datasheet) that has to be on top. Is what RobJ said also aplliable to a subform?

 

[bensmeets]

for example

clearifying my problem...

*img deleted to releave my server *

 

[KevinM]

That way you would need two subforms in one form, which is perfectly normal, but in your case I would do as suggested and simply select or display ONE person in the main form and view their data in the subform.

 

[Mile-O]

Rather than use a subform for the top part, or a combobox, you can take what may be a better option - a listbox - that way you can view more than one name but select one and it will update in the lower half.

 

[bensmeets]

Rather than use a subform for the top part, or a combobox, you can take what may be a better option - a listbox - that way you can view more than one name but select one and it will update in the lower half.

Oh my god, the control was sitting there on the toolbox the whole time....silly me. Tnx to all for the help. My intendend application users will be gratefull