2 Subforms, one master

[Guest]

Hi,
I have a main form, a subform (1) and two further subforms embedded in tab
controls.
Main Form: Actual Cost
Subform: CostJob Subform
Subforms (2): CostDetails Subform and EstDetails Subform

The 2 'Details' subforms are the same, but I have a field (Control) called
CostDate. If it is Null then it is an Estimate otherwise it is a Cost.

My problem is that only the CostDetails Subform behaves correctly. That is
if I go to the second row in the first subform CostJob Subform, the
corresponding data changes in the CostDetails Subform.
I though it was to do with the master & child fields. I have the same fields
set for both Details Subforms, i.e.:
Master:[CostJob Subform].Form![JobID]
Child:JobID

Any suggestions?

Thanks,

Graeme

 

[Arvin Meyer [MVP]]

If I understand correctly, you need the second subform to be based upon the
first subform, not the main form:

Sub2
Sub1 Sub2ID
Main Sub1ID>>>>>>>>>Sub1ID
ID>>>>>>>>>MainID

 

[Guest]

Hi Arvin,
Yes, that is correct the 2nd subform should be connected to the first.
I don't know what I'm doing wrong though!
I usually just use the form wizard - so am unaware of shortfall.

Cheers,

Graeme

If I understand correctly, you need the second subform to be based upon the
first subform, not the main form:

Sub2
Sub1 Sub2ID
Main Sub1ID>>>>>>>>>Sub1ID
ID>>>>>>>>>MainID
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi,
I have a main form, a subform (1) and two further subforms embedded in tab
controls.
Main Form: Actual Cost
Subform: CostJob Subform
Subforms (2): CostDetails Subform and EstDetails Subform

The 2 'Details' subforms are the same, but I have a field (Control) called
CostDate. If it is Null then it is an Estimate otherwise it is a Cost.

My problem is that only the CostDetails Subform behaves correctly. That
is
if I go to the second row in the first subform CostJob Subform, the
corresponding data changes in the CostDetails Subform.
I though it was to do with the master & child fields. I have the same
fields
set for both Details Subforms, i.e.:
Master:[CostJob Subform].Form![JobID]
Child:JobID

Any suggestions?

Thanks,

Graeme