form field not updating

[Guest]

I have a table called Accounts and another called contacts. The contacts is
linked to the Accounts by the contact Id. In the contacts table there are 2
fields called first name and last name. In a query I create a new field
called full name: [first name]&" "&[last name]. On a form I created a drop
down box to select the contact for the account. When I select a name from
the drop down it does not update the full name field on the form. When I do
this directly in the query it does update the full name field. How come it
does not update the field on the form when the contact changes?

 

[Guest]

Hi, Patricia.

Check the Control Source of the combo box. Most likely, it is not bound to
the ContactID field in the underlying table. Also check the combo box' Row
Source, BoundColumn and ColumnWidths properties. The RowSource should be
selecting the ContactID and your concatenated full name field from your
query, in that order; the Bound Column should be set to 1, and the
ColumnWidths should be set to 0";x", where x = a width in inches large enough
to display the widest name in your list.


Hope that helps.
Sprinks