2 Subforms, one master

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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

Arvin Meyer said:
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

Graeme at Raptup said:
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
Click to expand...
Click to expand...
 
Back
Top