K
Kelly
Is it possible to have a lookup on an fieldID that will populate information
from a paste appended table to a subform and also allow you to enter new data
that will be saved back to that table.
Example:
Three tables thus far involved. Mainform is from table Conduit, subform will
have a query to pull from the other two forms. CircuitDetail and Circuits.
Table Conduit has fields: ConduID,ConduitName,
SecondaryConduitName,DwgNum,SizeOfConduit,ConduitNumber
Table Circuits has fields: CircID, CircuitName, Kmark,Description,FromEq,
ToEq these are populated from an Excel spreadsheet with paste append. OR be
data entry from scratch in the subform.
The other table CircuitDetail has fields:
CircuitID,CircNameID,ConduitID,NumOfConds,LengCable,CircRevNum
The main form master link is ConduID Primary Key and the child link ConduitID.
The main goal of the form is to have a Conduit Name associate with several
Circuits but have the flexability to pull from a lookup that will allow to
write back to the Circuits table if something is added. Have the CircNameId
populate the Circuits table fields in the subform from a combo box dropdown.
There are several other elements to this form that need to be addressed but
this is the biggy.
I tried to use a RecordsetClone and I must be missing something because this
doesn't work. I also looked at NotInList but they would have to answer a
question with every entry with going from scratch. Is there a solution to my
problem?
This has dealt me fits on how to achieve the results I need.
Kelly
from a paste appended table to a subform and also allow you to enter new data
that will be saved back to that table.
Example:
Three tables thus far involved. Mainform is from table Conduit, subform will
have a query to pull from the other two forms. CircuitDetail and Circuits.
Table Conduit has fields: ConduID,ConduitName,
SecondaryConduitName,DwgNum,SizeOfConduit,ConduitNumber
Table Circuits has fields: CircID, CircuitName, Kmark,Description,FromEq,
ToEq these are populated from an Excel spreadsheet with paste append. OR be
data entry from scratch in the subform.
The other table CircuitDetail has fields:
CircuitID,CircNameID,ConduitID,NumOfConds,LengCable,CircRevNum
The main form master link is ConduID Primary Key and the child link ConduitID.
The main goal of the form is to have a Conduit Name associate with several
Circuits but have the flexability to pull from a lookup that will allow to
write back to the Circuits table if something is added. Have the CircNameId
populate the Circuits table fields in the subform from a combo box dropdown.
There are several other elements to this form that need to be addressed but
this is the biggy.
I tried to use a RecordsetClone and I must be missing something because this
doesn't work. I also looked at NotInList but they would have to answer a
question with every entry with going from scratch. Is there a solution to my
problem?
This has dealt me fits on how to achieve the results I need.
Kelly