B
briandis14
Guest
I wonder if anyone can help me with this problem. Each department within an organization is assigned a unique 7-digit number. Both the name and the ID number are used on a particular form. What I would like to do is set up this form so that, as the department's number is entered into a field, that department's name would be automatically entered into an adjacent field. I had some luck using a two-column combo box that referenced the names from another table in my database. This table simply lists each department and its number. But, since I changed the 'department name' Record Source to coincide with the first column of the combo box (myfield = [combobox].[column](0)), the value is no longer entered in the table's datasheet. So, I would like the name to be entered automatically in the form's field, but still need both values to show up on the table. If that means leaving the Record Source alone, is there a solution using visual basic? If anyone can help, I'd appreciate it...