subform population and viewing

[Cynthia]

I cannot get the fields I need in the subform to show on the main form and be
able to fill in the necessary data.

I have 3 tables and 3 forms listed below

Table called ELECABLETYPE
Fields with two lines populated
ID (AUTO);TYPE;NO_CONDUCTORS;SZ_CONDUCTORS;OD;PULLTENSION;
1 PM 4C 12 2 0
2 LS 12P 4/0 1
0

Table called ELEWIRES
Fields
ID (AUTO) CABLEID (Match ID field table ELECABLETYPE) WIRE


Form called frmWires
Fills in ELEWIRES table as shown below the user fills in the wire field.
I use this as a sub form in the frmCABLETYPE. The user fills in the wire
number and the cable id is automatically filled in.
ID CABLEID WIRE
1 1 3A
2 1 3B
3 1 4
4 2 2C

Table called ELEWIRETERM
Fields
ID(AUTO) CIRCID CABLEID WIRE WTAPE TOTERM FRMTERM
I need this table populated from the circuit form below

Circuit table has a number of fields but I am only using the CIRCID,
CABLETYPEID and CABLETYPEID2 to link to the subform.

In the Circuit form I have a field for primary cable type and secondary
cable type. These are filled in with the ID field from the ELECABLETYPE
table at the top.
They are CABLETYPEID and CABLETYPEID2.

I would like to place a subform in the circuit form that will show all the
wires that have the matching ELECABLETYPEID and a second subform that will
show all the wires that ahve the matching ELECABLETYPEID2 and allow the user
to fill in the
WTAP TOTERM AND FRMTERM FIELDS. Problem is I need it to fill in the CIRCID
also because a CABLEID can be used on more than one circuit and
the fields WTAP TOTERM and FRMTERM will not be the same. If I pull in the
subform and try to match ELECABLETYPEID and CIRCID I will not get
any fields because the CIRCID does not show up on the ELEWIRETERM table
until after the input??
What is wrong with my logic?