Hi, Everyone
I have this small form to collect data base on a table with four fields; two{2} that are foreign keys to another Table..... Reasons to run a cross-tab Query for Data information. On the form has two combo box objects with drop-down information; However what am trying to get is the number key value in the combo box stored to table and not the actually description assign the the numbered key value. When I click a btn on the form to add records to the table only the date field cements whose control source is =Date(). Can you store the key value of a combo box to a table and not the actual info value assigned to the key from a Form , for example a drop down list of names but as records are added to a table you prefer the key value