New issue -- Drill Down from a continuous form

[Barry Davis]

I have created a continuous form. Each record is a time sheet.

Each time sheet has anywhere from one to 5 affiliated project sheets.

I would like to be able to put a button or something on the form so that clicking on the button for a specific record will call a new form showing the affiliated project sheets.

I've place the time sheet ID number in an invisible field on the continuous form and that can be used for selecting the affiliated forms. Obviously, the Time Sheet ID number is on each affiliated record.

I hope I've been clear and thanks for any help you can give me.

Barry Davis

EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorial...f-32b2d802ae17/wpf-datagrid-custom-pagin.aspx

 

[Steve Schapel]

Barry,

You may be interested in this article:
http://accesstips.datamanagementsolutions.biz/subsub.htm

 

[Frank H]

Another approach, if you don't want the regular main form / subform is to use
linked forms. It sounds like the Wizard will do just what you are asking for.
The Form Wizard might make really quick work of this, if you select fields
from both tables in the first step of the wizard, then in the second step
choose linked forms instead of Main/sub.
Or, perhaps the above will give you a place to start, and then you can tweak
it.
Frank H
Rockford, IL