Combo box to populate Unbound field

[Jason]

I have a continuous form. In the form header I have an unbound combo box that
allows the user to select an item. This updates the record source for the
form and filters the continuous section of the form to display on items
related to the selected one.

In the continuous section of the form, there is another combo box. I have
two columns, one is a number identifier (which is the bound data) and the
other is a description. I would like to display both the numerical identifier
(bound) and description (unbound) on continuous portion of the form. My
attempts have resulted in an unbound text box that displays the same value
for every record on the continuous portion of the form rather than a
different value for each record displayed.

 

[Marshall Barton]

I have a continuous form. In the form header I have an unbound combo box that
allows the user to select an item. This updates the record source for the
form and filters the continuous section of the form to display on items
related to the selected one.

In the continuous section of the form, there is another combo box. I have
two columns, one is a number identifier (which is the bound data) and the
other is a description. I would like to display both the numerical identifier
(bound) and description (unbound) on continuous portion of the form. My
attempts have resulted in an unbound text box that displays the same value
for every record on the continuous portion of the form rather than a
different value for each record displayed.

You can use a text box with an expression like:

=combobox.Colimn(1)

to display the second column in the combobox's RowSource
table.query.

 

[Peter Yang [MSFT]]

Hello Jason,

You may want to try Marsh's suggestions. If it does not apply to your
situation, will you please provide me with a sample database and send it to
me? You could remove "online" in my display email address. Thank you!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[J. Goddard]

Hi -

You have set the Bound Column property of the combo box - but have you
set the Control Source property of the combo box to one of the form's
source fields, i.e. the one that contains the data equivalent to the
combo box's bound column?

Once you do that, then Marshall's suggestion for the control source of
the text box should work.

John

 

[Marshall Barton]

Arrgghh, I hope my typo didn't throw you. It should have
been:
=combobox.Column(1)