Multiple Sub-Forms in a main form for editing

[Harley Guy]

I am having some problems trying to figure this out so I thought I would come to the experts.



I have a job-leveling database that I use to load level build stations on my factory floor. Each job has a list of tasks assigned to it along with TAKT times so that I can quickly see which job is near or over TAKT time or under.

What I would like to do would be to have a form come up with 2 sub-forms that are searchable. Then I can edit both jobs by moving one task from one to the other...

Is there a way to build that? I've seen a lot of single forms but I don't believe I've seen this option before.

Thanks!

[June7]

You want two subforms bound to the same dataset. Should be possible. Just don't try to edit the same record in both forms.