About to give up designed a table to track record review data. Data is entered via a form. All of the fields are updating the table EXCEPT for the ones that are automatically populated from a combo box.
Tables: Record Reviews (holds ALL fields to be entered from form)
Customers (holds customer #, first name, last name, account number)
Form: Record Review From which was built using form wizard and the Record Review Table
For example: when a case # is selected in the form, the customer first name, last name, and account number are automatically filled in based on information in a seperate table called customers. The remaining 20 fields in the form are manually entered (i.e. review date, status, outcome etc). When the form is closed the table (record reviews) is updated with all the information except for the customer first name, last name, and account number. What properties do i change in the form to get this to work? Relatively new to access so I am trying to figure it out my trial and error and so far ..... nothing has worked. Any help is appreciated.