C
Cynthia
I have a continuous form where the number of fields available to fill in
depends on a link to elewires. If cableid in my table links to
elewires.calbeid. For this example there are 3 records in elewires with cable
id 5. For the first time the users are doing this my fields are unbound and
I fill in the termid data through code.
They see 3 colors red, yellow, black which are stored in the wire field in
elewires.
When they need to edit I have a different form with the data linked so they
can see the termid info and matching color they have filled in.-- i.e. they
have filled in red and black, but yellow is blank. I cannot get the yellow
blank termid field to show so they know to fill it in.
I created the union query pasted below and they see all 3 fields with yellow
showing termid as blank but it is not updateable so they cannot set the
termid. How should I go about getting this form set up so they can edit it
and still see info already populated? I am at a loss and any help would be
appreciated.
SELECT EleWires.CableID, EleWires.WireID, EleWires.Wire, EleWireTerm.TermID,
EleWireTerm.SpareHold, EleWireTerm.TB_Name, EleWireTerm.MainEqpID,
EleWireTerm.SubCircID FROM EleWires LEFT JOIN EleWireTerm ON EleWires.WireID
= EleWireTerm.WIREID where (((EleWires.CableID) = 5) And SubCircID = 2310 and
maineqpid = 65114)UNION Select elewires.cableid, elewires.wireid,
elewires.wire, 0 as TermID, '' as SpareHold,'' as tb_name,'' as maineqpid, 0
as subcircid from elewires where cableid = 5 and wireid not in (select wireid
from elewireterm where subcircid = 2310 and cableid = 5 and maineqpid =
65114);
Cynthia
depends on a link to elewires. If cableid in my table links to
elewires.calbeid. For this example there are 3 records in elewires with cable
id 5. For the first time the users are doing this my fields are unbound and
I fill in the termid data through code.
They see 3 colors red, yellow, black which are stored in the wire field in
elewires.
When they need to edit I have a different form with the data linked so they
can see the termid info and matching color they have filled in.-- i.e. they
have filled in red and black, but yellow is blank. I cannot get the yellow
blank termid field to show so they know to fill it in.
I created the union query pasted below and they see all 3 fields with yellow
showing termid as blank but it is not updateable so they cannot set the
termid. How should I go about getting this form set up so they can edit it
and still see info already populated? I am at a loss and any help would be
appreciated.
SELECT EleWires.CableID, EleWires.WireID, EleWires.Wire, EleWireTerm.TermID,
EleWireTerm.SpareHold, EleWireTerm.TB_Name, EleWireTerm.MainEqpID,
EleWireTerm.SubCircID FROM EleWires LEFT JOIN EleWireTerm ON EleWires.WireID
= EleWireTerm.WIREID where (((EleWires.CableID) = 5) And SubCircID = 2310 and
maineqpid = 65114)UNION Select elewires.cableid, elewires.wireid,
elewires.wire, 0 as TermID, '' as SpareHold,'' as tb_name,'' as maineqpid, 0
as subcircid from elewires where cableid = 5 and wireid not in (select wireid
from elewireterm where subcircid = 2310 and cableid = 5 and maineqpid =
65114);
Cynthia
have an awesome day