Vertical Master Detail with left/right layout.

[lawman]

I'm trying to create a form with following layout.



1. Left vertical column with Tasks datasheet form, showing columns Task, Case, Date, Status
2. Right column with Full details of the Case in currently selected Task row.
3. The above 2 forms are therefore linked by Case PK/FK.
4. This would look almost like ms-outlook, where you have a list of messages on your left and depending on which you select, further contents of that message show on the right.

Can somebody please guide me on how to best do this.

I've tried guides but find:

a. They always have master/detail horizontally above/below the other instead of left/right. Can't seem to place this when I try.
b. If I create Tasks subform into Case mainform, this only shows me tasks for that single Case. I don't want to see all Tasks for all Cases, as thats the main form.
c. If I create a Case subform into a Tasks mainform, this results in only showing a tasks form which now has an expandable row option via + symbol, that lets me see the case details on expansion. This isn't what I want.
d. I want to be able to scroll up and down the left tasks data sheet list, and the right part of my screen auto changes the case to that in current task selected, with full details about that case.

Hope the above makes sense.

Complete newbie as is obvious from the question, so pls keep it in layman terms.

Thanks in advance.

[Micron]

Have never tried, but it sounds like you'd need a form with 2 subforms. You cannot do this with one main and one subform. If you search you will find many results for how to link 2 subforms together. There is also something called a Tree View control but I think you will find it a bit daunting to control. It is also an ActiveX control (IIRC) which can be problematic in terms of supporting over different pc's and/or OS versions. Plus M$ sometimes discontinues support for ActiveX controls.

[CJ_London]

Sounds like micron's suggestion of two subforms is the way to go.

on the main form have a hidden textbox control called say txtLink

in the left subform current event put something like


parent.txtLink=me.ID


for your right subform control use the linkchild/master properties to set the master to txtLink and child to the relevant field in the subform

[kd2017]

Suggested reading:
1) http://fmsinc.com/microsoftaccess/fo...edSubforms.asp
2) http://fmsinc.com/MicrosoftAccess/fo...ink-Fields.asp

[mike60smart]

Hi
I use this method all the time. 1 Unbound Form and then the 2 subforms side by side.

To link the forms use the standard method of an Unbound Control :- =[Forms]![NameofMainUnboundForm]![NameofLeftSubform].[Form]![NameofPrimaryKeyID]

You then name this unbound Control:- txtPrimarkKeyID

Then in the Properties of the Right Hand Form LinkMaster = txtPrimarkKeyID and LinkChild =ForeignKeyID

[Minty]

Cross posted here https://www.access-programmers.co.uk...-forms.315306/ with answers.

[lawman]

Hi
I use this method all the time. 1 Unbound Form and then the 2 subforms side by side.

To link the forms use the standard method of an Unbound Control :- =[Forms]![NameofMainUnboundForm]![NameofLeftSubform].[Form]![NameofPrimaryKeyID]

You then name this unbound Control:- txtPrimarkKeyID

Then in the Properties of the Right Hand Form LinkMaster = txtPrimarkKeyID and LinkChild =ForeignKeyID

I can manage to do above.

However, the problem is how to reference hidden bound column 1 of a combobox in LeftSubForm. I can only manage to reference the visible data in LeftSubform combobox.

ie. =[frmKeydates].[LeftSubForm]![ComboboxControl]

How do I reference hidden bound column 1 of ComboBoxControl instead of the visible column 2.

[lawman]

Cross posted here https://www.access-programmers.co.uk...-forms.315306/ with answers.

Are these not 2 separate sites with different postings and users?

Didn't realise we should only use one site?

[ssanfu]

I would say it is acceptable to cross post *IF* you put a notice in both/all cross posts as to where you have also posted your question.
See Cross posting Etiquette

[mike60smart]

you can reference the first hidden bound column 1 of a combobox using a standard form reference
ie =[Comboboxname].Column(0)

Then use this in your Textbox link to the other subform