Br@dley wrote:
Create a text field and set it's controlsource as...
=[MyComboBox].Column(1)
Change the value of the column number to suit the one you want. Note:
column numbers start at zero.
--
Thank you for taking the time to reply. I believe I understand what
is going on here now. You use the query that populates the combo box
to also pull the data for this field. I did that by altering the query
code in the Row Source for the combo box. Then, I set the Column
Widths to 0";1";0" and increased the Column Count to 3. (The table
that Im referencing actually has a RecordID column as the first column,
so I have been doing this type of thing right along... but didnt
realize it. I bound to column 1.)
I then placed your suggestion in the Control Source for the text field.
Unfortunately, I get the same error.
I did receive another private email with the suggestion that I put code
in the AfterUpdate event of the combo box and push the value to the
field. Essentially, it the same code. Now, that works! The only
problem is that when you move off the record, the field is still
populated. I have to include some code to constantly set it the the
right value for the current record.
Any idea why that would be? At any rate, it appears that I have this
issue resolved. Thanks again for your efforts.