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
