continuous form question

[SpiritedAway]

Hi

I have a main form frmproject which is linked to master/child to frmArea (this was a single form) by [projectID]

frmArea is then linked to another subform frmProcess master/child by [AreaID]

I'm trying to get frmArea and frmProcess as two continuous forms - I've embedded both forms on an unbound form with a text box with control source =[frmArea].[Form]![AreaID] and linked this master/child to frmProcess.

This means when i click on the frmArea all the related data appears in frmProcess which is what I want.

But does anyone know how I then link this unbound form to frmproject by [projectID] so that the related info in frmArea is displayed in the continuous form.

I could do it if frmArea was a single form, but how do so with a continuous form?



Thanks for your help

 

[stopher]

If I understand your question correctly, here's how I'd implement the forms:

I'd have my main form frmproject (bound).

I'd add frmArea as a continuous subform in the main form and link to main form using master/child.

I'd add frmprocess as a continuous subform in the main form.

In order to have frmprocess show the correct record I would create an OnCurrent event in the frmArea subform to update the record filter for frmprocess.

hth
Chris

 

[SpiritedAway]

Thanks for your reply Chris,

Do you know what kind of code I use to filter record on the Oncurrent event in the frmArea subform?

Thanks

 

[stopher]

Take a look at this thread which has some discussion as well as examples.

hth
Chris

 

[SpiritedAway]

Great i'll take a look - thanks Chris