Changing information display method in forms

[mrbaggins]

Currently using a form for person details to show names, with each record being a person.



There is a subform below this that shows all the activities the current person has in the system.

The form displays as just label-textbox style while the subform is a datasheet of all relevant info.

Is there some way to make the form itself be a datasheet of person details (or a dropdown, prefer multi-item list though) that when a person is selected, the subform updates? I've tried a few things but nothing works.

Related problem, I have a drop down elsewhere in the program that displays a list of activities and lets the user jump to a specified one in the form. Is there someway to make a drop down show information from 2 or more separate fields? Even better, to show information from 2 or more separate fields, PLUS format it? (IE: Make it pull name and date, but display "Cricket (2010)")

[HiTechCoach]

I have an example that shows how to use two sub form that are linked. When you select a record in the top sub form, then lower sub form displays the related records.

See:
Documents stored in tables

[mrbaggins]

Thanks, hadn't thought of putting two sub forms in... That sounds like it fixes the first problem, at least to some extent... Any word on the other other parts?

[HiTechCoach]

Related problem, I have a drop down elsewhere in the program that displays a list of activities and lets the user jump to a specified one in the form. Is there someway to make a drop down show information from 2 or more separate fields? Even better, to show information from 2 or more separate fields, PLUS format it? (IE: Make it pull name and date, but display "Cricket (2010)")

Sure. Use a calculate query field

Example In Query Designer:

 
DisplayText: [Namefieldname] & " (" & Tear([dateFieldName]) & ")"

Example In SQL:

 
 [Namefieldname] & " (" & Tear([dateFieldName]) & ")" as DisplayText

[HiTechCoach]

Also see this example:

25 Cool Control Tricks

[mrbaggins]

Thanks a bunch for the help. I actually gotten part way towards that with another part of the program, however was helped along a lot of the way with the wizard.