I have been working on a form to create a transactions table for logging in and out equipment. My problem process has been automatically pulling an employees shift # to the form when that employee is selected. I used a combo box that pulled necessary data from a table called employees. I then created an unbound text box with the following control source:
=[Checked_Out_To].[column](2)
to populate the Shift box on the form. When the employee is selected, the correct shift number shows up in the text box. However, when I click the button to update the record, that shift information is not being copied to the Transactions table