Hello,
I want to do the following.
I have a combo box with a field named "Approving Official". This will contain names. In the same form i have a number field (AO_CC-text box) that i want to update automatically based on the "Approving Official" value.
I followed the instructions below.....
The Row Source of the combo box needs to include both columns (fields). You can set the width of the Number column to 0 if you don't want it to be shown when the combo box is expanded. Then, in the Control Source of the text box put;
=[YourComboBox].Column(1)
It is a zero based index, so the first column (in this case the Name field) is Column(0), the second column (in this case the Number field) is Column(1), etc.
Here is what it looks like....
Approving Official Control Source -
SELECT DISTINCT Contacts.ID, Contacts.LastName, Contacts.CC FROM Contacts WHERE (((Contacts.Position)="AO")) GROUP BY Contacts.ID, Contacts.LastName, Contacts.CC ORDER BY Contacts.LastName;
Bound column = 1
AO_CC
=[ApprovingOfficial].[Column](2)
This worked BUT when data is input in the form, the AO_CC field is NOT updating in the table. The other fields i am entering is updating in the table. The AO_CC field is not.
Why is that occuring?
Thanks