Standard Jet DBnb` Ugr@?~1y0̝cǟFN7]D^(`T{6u߱wCϯ34ay[|*|OJl>`&_Љ$g'DeFx -{NKKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl O XFIELD       mO YFIELD       mO ZFIELD       mKKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl O XFIELD       mO YFIELD       mO ZFIELD       mKKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl O AFIELD       mO BFIELD       mO CFIELD  VCS           2                   IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra  Id ParentIdName          ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  d+UOs#@d+UOs#@UserDefined***********  d+UOs#@d+UOs#@SummaryInfo***********  d+UOs#@d+UOs#@AccessLayout+++++++++++ d+UOs#@d+UOs#@SysRel%%%%%%%%%%% d+UOs#@d+UOs#@Scripts&&&&&&&&&&& d+UOs#@d+UOs#@Reports&&&&&&&&&&& d+UOs#@d+UOs#@Modules&&&&&&&&&&& d+UOs#@d+UOs#@Forms$$$$$$$$$$$ d+UOs#@d+UOs#@MSysRelationships22222222220 d+UOs#@d+UOs#@MSysQueries,,,,,,,,,,* d+UOs#@d+UOs#@MSysACEs))))))))))' d+UOs#@d+UVC?S     2  ObjectIdSIDACM FInheritable ObjectId }r#@ws#@AccessLayout*@-@,E99-------+ @ROGwr#@ROGwr#@SysRel''''''''''% ROGwr#@ROGwr#@Scripts((((((((((& ROGwr#@ROGwr#@Reports((((((((((& ROGwr#@ROGwr#@Modules((((((((((& ROGwr#@ROGwr#@Forms&&&&&&&&&&$ PFwr#@PFwr#@MSysRelationships22222222220 PFwr#@PFwr#@MSysQueries,,,,,,,,,,* PFwr#@PFwr#@MSysACEs))))))))))' PFwr#@PFwr#@MSysObjects,,,,,,,,,,* PFwr#@Fwr#@MSysDbE@-333'''''''% @PFwr#@PFwr#@Relationships.........., PFwr#@PFwr#@Databases**********( PFwr#@PFwr#@Tables''''''''''% VCEN __A__ &ys#@&ys#@UserDefined***********  &ys#@&ys#@SummaryInfo***********  &ys#@&ys#@AccessLayout+++++++++++ &ys#@&ys#@SysRel%%%%%%%%%%% &ys#@&ys#@Scripts&&&&&&&&&&& &ys#@&ys#@Reports&&&&&&&&&&& &ys#@&ys#@Modules&&&&&&&&&&& &ys#@&ys#@Forms$$$$$$$$$$$ &ys#@&ys#@MSysRelationships22222222220 &ys#@&ys#@MSysQueries,,,,,,,,,,* &ys#@&ys#@MSysACEs))))))))))' &ys#@&ys#@MSysObjects,,,,,,,,,,* &ys#@&ys#@MSysDb''''''''''% &ys#@&ys#@Relationships.........., &ys#@&ys#@Databases**********( &ys#@&ys#@Tables''''''''''% {@@ @ d`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdVCe N            FlagsFormModuleNameReplicationVersionTypeTypeInfoVersion!Index1 &ys#@&ys#@UserDefined***********  &ys#@&ys#@SummaryInfo***********  &ys#@&ys#@AccessLayout+++++++++++ &ys#@&ys#@SysRel%%%%%%%%%%% &ys#@&ys#@Scripts&&&&&&&&&&& &ys#@&ys#@Reports&&&&&&&&&&& &ys#@&ys#@Modules&&&&&&&&&&& &ys#@&ys#@Forms$$$$$$$$$$$ &ys#@&ys#@MSysRelationships22222222220 &ys#@&ys#@MSysQueries,,,,,,,,,,* &ys#@&ys#@MSysACEs))))))))))' &ys#@&ys#@MSysObjects,,,,,,,,,,* &ys#@&ys#@MSysDb''''''''''% &ys#@&ys#@Relationships.........., &ys#@&ys#@Databases**********( &ys#@&ys#@Tables''''''''''% {qg@@ @ gruoWd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdHLVALTQi'Qm9&ys#@&ys#@MSysModules2+++++++++++ &ys#@&ys#@MSysModules*********** &ys#@&ys#@Form1$$$$$$$$$$$  &ys#@&ys#@UserDefined***********  &ys#@&ys#@SummaryInfo***********  &ys#@&ys#@AccessLayout+++++++++++ &ys#@&ys#@SysRel%%%%%%%%%%% &ys#@&ys#@Scripts&&&&&&&&&&& &ys#@&ys#@Reports&&&&&&&&&&& &ys#@&ys#@Modules&&&&&&&&&&& &ys#@&ys#@Forms$$$$$$$$$$$ &ys#@&ys#@MSysRelationships22222222220 &ys#@&ys#@MSysQueries,,,,,,,,,,* &ys#@&ys#@MSysACEs))))))))))' &ys#@&ys#@MSysObjects,,,,,,,,,,* &ys#@&ys#@MSysDb''''''''''% ͬWdoKĀDetailoCombo0d Table_1_records__LabelTable 1 records:_Labeld Label2d Label3h Command4LVAL i_VBA_MODULEzWdoKĀWdoKĀxn2 [LS S<0<&<4<<<< <$<(<,<8<<<N0{E26457D6-A86F-11D5-B2BC-00104BC5C480}0($`  $ D `p@01 $ $ "x $X $  $ $Jd m.HT 1@D Com@ @0 Colu@ @  @ @ rogr@ s\Mi@ ba33@ @ @ @ 3@ icro@p SACC `TMEA " N0 N 2 ?H < (H * p :LVAL  *  6H 4  8 < 8H ,   :@ 4HH .    <  ( "px     xpZl`lPH this code shows how to "copy" values in a combo box row to other fieldsH in a table. In this example, we are inserting records in a second table+ but the technique is pretty much the same.o5 first, find the record in the 2nd table that matches! the key chosen in the combo box. PrimaryKey "(0 "%: ")8$ use the primary key index of Table23 find the record in Table2 who's key is the same as$ the bound column from the combo box/ We know it will work, so I'm not including any. error checking code here, but you may need to think about that.2 OK, now we've found the record in Table2 that has6 the same key as the combo box. Let's go into "update"2 mode, and update the record in Table2 to have the& values in the other combo box columns "B@2 "%: ")> "B@D%: "B@B Me!= " "B@H." first, go in to Edit Mode4 next, simply assign the values in combo box columns- to the fields in Table2 that are appropriate' write the changes/update to the record close the table5 and free up the SET assignment to release the memoryTable2 *%,."`L` NB@BPHu@L8 T!V1LVAL=A@RP lAttribute VB_Name = "Form_ 1" Bas0{E26457D6-A86F-11D5-B2BC-00104BC5C480} |CreatablTrue PredecdlaId"E xposeFals @TemplateDeriv%Customiz$Optio@n Comp@ fDTv  BDA@O *\G{000@25E01-0C  0046}#4.0#0#C:\Program Files\Common Microsoft Shared\w\dao350.dll# 3.51 Object Li`braryH2 Form_!1 _VBA_MODULE2V"Bo_MqDULE (H1X ,2T"(+gruo,gruoWov}vda &ys#@&ys#@UserDefined***********  &ys#@&ys#@SummaryInfo***********  &ys#@&ys#@AccessLayout+++++++++++ &ys#@&ys#@SysRel%%%%%%%%%%% &ys#@&ys#@Scripts&&&&&&&&&&& &ys#@&ys#@Reports&&&&&&&&&&& &ys#@&ys#@Modules&&&&&&&&&&& &ys#@&ys#@Forms$$$$$$$$$$$ &ys#@&ys#@MSysRelationships22222222220 &ys#@&ys#@MSysQueries,,,,,,,,,,* &ys#@&ys#@MSysACEs))))))))))' &ys#@&ys#@MSysObjects,,,,,,,,,,* &ys#@&ys#@MSysDb''''''''''% &ys#@&ys#@Relationships.........., &ys#@&ys#@Databases**********( &ys#@&ys#@Tables''''''''''%  oC  Table1.AFIELD% '  Table1.CFIELD% g  Table1.BFIELD% g  Table1.AFIELD% g Table1   G  G    VCN$$  d  rid  dAFIELDBFIELDCFIELD$&  PrimaryKey &ys#@&ys#@Query1%%%%%%%%%%% &ys#@&ys#@MSysModules2+++++++++++ &ys#@&ys#@MSysModules*********** &ys#@&ys#@Form1$$$$$$$$$$$  &ys#@&ys#@UserDefined***********  &ys#@&ys#@SummaryInfo***********  &ys#@&ys#@AccessLayout+++++++++++ &ys#@&ys#@SysRel%%%%%%%%%%% &ys#@&ys#@Scripts&&&&&&&&&&& &ys#@&ys#@Reports&&&&&&&&&&& &ys#@&ys#@Modules&&&&&&&&&&& &ys#@&ys#@Forms$$$$$$$$$$$ &ys#@&ys#@MSysRelationships22222222220 &ys#@&ys#@MSysQueries,,,,,,,,,,* &ys#@&ys#@MSysACEs))))))))))' &ys#@&ys#@MSysObjects,,,,,,,,,,* &ys#@&ys#@MSysDb''''''''''% &ys#@&ys#@Relationships.........., &ys#@&ys#@Databases**********( &ys#@&ys#@Tables''''''''''% a{q @ " " " " " " " "@ #@@   gruoWd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvtxfu}W`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdREC5MOUSESQUEAK REC4SHARKSWIM REC3BIRDFLY REC2CATMEOW REC1DOGBARK #@ufbW%ufbX%ufbY%ufbZ%ufb[%       IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra  Id ParentIdName          ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  d+UOs#@d+UOs#@UserDefined***********  d+UOs#@d+UOs#@SummaryInfo***********  d+UOs#@d+UOs#@AccessLayout+++++++++++ d+UOs#@d+UOs#@SysRel%%%%%%%%%%% d+UOs#@d+UOs#@Scripts&&&&&&&&&&& d+UOs#@d+UOs#@Reports&&&&&&&&&&& d+UOs#@d+UOs#@Modules&&&&&&&&&&& d+UOs#@d+UOs#@Forms$$$$$$$$$$$ d+UOs#@d+UOs#@MSysRelationships22222222220 d+UOs#@d+UOs#@MSysQueries,,,,,,,,,,* d+UOs#@d+UOs#@MSysACEs))))))))))' d+UOs#@d+UVCN((  d  rid  dXFIELDYFIELDZFIELD(*  PrimaryKeya{q'@@  @ @gruoWd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvtxfu}Ww`amfW`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdREC5REC4REC3REC2REC1'@ufbW)ufbX)ufbY)ufbZ)ufb[)       IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra  Id ParentIdName          ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  d+UOs#@d+UOs#@UserDefined***********  d+UOs#@d+UOs#@SummaryInfo***********  d+UOs#@d+UOs#@AccessLayout+++++++++++ d+UOs#@d+UOs#@SysRel%%%%%%%%%%% d+UOs#@d+UOs#@Scripts&&&&&&&&&&& d+UOs#@d+UOs#@Reports&&&&&&&&&&& d+UOs#@d+UOs#@Modules&&&&&&&&&&& d+UOs#@d+UOs#@Forms$$$$$$$$$$$ d+UOs#@d+UOs#@MSysRelationships22222222220 d+UOs#@d+UOs#@MSysQueries,,,,,,,,,,* d+UOs#@d+UOs#@MSysACEs))))))))))' d+UOs#@d+U8.o`QB qbO@1"s`QBM>/LDYFIELDZFIELD  ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Tۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   LVAL @ @ @+++++++++ ++++++++++++++++ + + + (,I&bTable1ʾTable2Query1Form1Rb(LVAL+      KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl O XFIELD       mO YFIELD       mO ZFIELD       mKKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl O AFIELD       mO BFIELD       mO CFIELD       mKKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDTitleAuthorCompanyD EKFORUM1 Jim Hare, AOS-320 CTR FAAKKD AccessVersionBuild%  07.53 KKD KeepLocal T}~ok\MI:+' 'ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ' # #ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o #    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   Tۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o