Populating form from ComboBox

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

I am fairly new to forms and I have a query with Name, Address, Phone etc...
and would like to fill the Address and Phone fields by selecting a name from
the ComboBox. Any help will be GREATLY appreciated.
 
I am fairly new to forms and I have a query with Name, Address, Phone etc...
and would like to fill the Address and Phone fields by selecting a name from
the ComboBox. Any help will be GREATLY appreciated.
Click to expand...


Are you trying to *store* the address and phone fields from the
Address table into some other table? If so... DON'T. It's *not*
necessary nor wise to store such information redundantly in a second
table; if you need it on a Report, just base the Report on a query
joining the report's table to the Address table by the unique
AddressID.

If you just want to *display* the address and so on, just include all
the fields that you want to see in the combo box's RowSource; put
textboxes on the Form with control source properties like

=cboAddress.Column(n)

where (n) is the *zero based* subscript of the desired field in the
combo box.
 
Back
Top