Access Form, how do I update various fields based on Combo Box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a simple form based on a customer table. I want to be able to pick
the name from a Combo Box, (that part works) then have the address, city,
state, ect, fields update with that customer's information.
 
include those additional fields in the combo box's RowSource. you can set
their column widths to zero (0), so they don't show in the droplist.

to *display* the address, city, etc values in unbound textboxes in the form,
set those textboxes' ControlSources to the appropriate column in the combo
box, as

=[ComboBoxName].[Column](1)

note that combo box columns are zero-based. so column 1 is (0), column 2 is
(1), etc.

you can save the data into bound textboxes by using SetValue macros or VBA
code, with the same control reference stated above. BUT, storing the same
data in multiple tables is a violation of data normalization rules, and is
very very rarely necessary. if that's what you're doing, recommend you
rethink your table design because you very likely do NOT need to store
duplicate data.

hth
 
Back
Top