<cappelquist@gmail.com> wrote
[color=blue]
> I want a main form that has a large List Box
> on the right side of the main form that will list
> Projects by name. In the top right section of
> the main form, I want a sub-form that will be
> a Datasheet format that will list Tasks for a
> given Project.[/color]
To each his own, they say, but most people are accustomed to seeing the
summary / overall view at the top, then the detail view below that.
Secondly, I can't recommend strongly enough that you use a Continuous Forms
View Form in your Subform (though, if you feel compelled to do so, you can
show it in Datasheet view). Datasheet view is for end-user use of the DB,
and gives inexperienced users too many opportunities to do something
"unexpected" in a developed application. Forms provide events that you can
use to control the application.
[color=blue]
> So, I want to be able to Highlight a Project in
> the Right side Projects List Box and have the
> Tasks associated to THAT Project appear in the
> Top right "prjTasks" sub-form.
>
> I've done some work with Subforms, but I need
> help with making it work by clicking on the List
> Box entry.[/color]
Be sure, as Salad has suggested, to include the prjID Field as the bound
column in your listbox, though you can size the column so it is not visible,
if you wish. However, instead of his approach of creating a filter, you can
simply use the name of the List Box (provided it can be distinguished from
the Field... I'd call it lstProject) as the LinkMasterFields and the
corresponding foreign key Field in tblProjectTasks as the LinkChildFields.
Selection of the appropriate Tasks will then be automatic when you choose a
project from the List Box... you will not need to create the criteria clause
and filter that form.
[color=blue]
> Second level - In the Bottom right, I want to show
> specifics about a given TASK, so that if I select
> the project "Make a Sandwich" and then select
> the 3rd task in the task list for making a sandwich -
> "Put Mayo on Bread" , I would see specifics, like
> Due Date for the task, Priority, Person assigned
> the task, and a large text box for a detailed
> task description.[/color]
It is not clear whether you intend this to be on the main Form or in another
Subform Control. Even if it is at the same level as the Subform from which
you chose the Task, you can, with proper "qualification" refer to the Task
ID in that subform as the LinkMasterFields.
[color=blue]
> I have a Table called tblProjects with key field
> prjID, and a table called tblProjectTasks with
> a key field tskID and a field : prjID being
> the foreign key to the key field in tblProjects.
>
> I think I can handle most of it, if I get a little
> help with populating the top right sub-form
> when a given entry in the list box has focus.[/color]
All that said, you may be able to accomplish your purpose in an easier
manner by using two List or Combo Boxes and the approach described in
http://www.mvps.org/access/forms/frm0028.htm, an article entitled "Forms:
Limit content of combo/list boxes".
Larry Linson
Microsoft Access MVP
