I am using Access 2007 and have a form that was primarily set up for viewing and editing data in a table. I have a combo box - from an unbound control - that searches and displays records based on a field called Cost Code. It is not the primary key for this table.
Now I want to give the user the capability to add records for a given (valid) cost code. That is, they will select a cost code and display all records for it. Then they can add more records if they like.
But when I add data for a new record I get a blank cost code value when I go into the table. Why is that?
How can I get this field to populate the cost code value automatically when I am creating a new record?