Field Link

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

Guest

This seems like a simple issue but could use help on how to best approach a
design issue.

I have two tables 1) Client 2) Representative with a one to many relationship.

In the Client Form, I have a combo box for selecting the many
representative. I'd like to have fields automatically fill-in with the
representative information once selected.

Any suggestions is appreciated
 
"fill-in with the representative information"... are these bound or unbound
controls? You can display other fields/columns from a combo box with control
sources like:
=cboRepresentative.Column(x)
Column number "x" is based on zero.
 
Back
Top