Field Population

  • Thread starter Thread starter groffj24
  • Start date Start date
G

groffj24

How do I get all fields to populate when I choose, say, a custome
number, to get all of its related fields ie, address,city,state,zip.
drop down the menu and choose a customer number but its not populatin
the fields like I want it to. I know this is probably a very simpl
procedure but I'm brain dead and can't figure it out today!

HELP!!!
Judy:confused
 
How do I get all fields to populate when I choose, say, a customer
number, to get all of its related fields ie, address,city,state,zip. I
drop down the menu and choose a customer number but its not populating
the fields like I want it to. I know this is probably a very simple
procedure but I'm brain dead and can't figure it out today!
Click to expand...

Are you trying to store the related fields redundantly in a second
table? If so, STOP: it is neither necessary nor beneficial to do so!

What's the context? Do you want to find an existing customer record on
a form based on the customer table? or do you just want to *see* the
address etc. on a form based on some other table? If so, include all
the fields you want to see in the combo's RowSource and include
textboxes with control sources like

=cboCustomerID.Column(n)

where (n) is the zero-based subscript of the desired field.
 
Back
Top