How can I update a field on an access form with information based on another
field. I want to be able to put in the customer name and their customer
number to automatically be displayed in another field.
First off... tables have Fields; forms don't. Forms have "Controls" such as
textboxes or combo boxes which may or may not be bound to fields in a Table.
So... what's the structure of your tables? How are they related? What's the
Recordsource for this form? Where are the customer name and customer ID to be
found?
I'm *guessing* here, not knowing the answers to the above - but you could have
a Combo Box on the form based on the Customers table (and probably bound to
the CustomerNumber field in this form's table). Include the customer name in
the combo box's rowsource, and you could put a textbox on the form with a
Control Source such as
=comboboxname.Column(n)
where n is the zero based index of the customer name field in the combo box's
rowsource query.
