Populate a field value

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

Guest

I have a control on my main form called [cboBC]: It's a lookup list with the
fields of :

Region BCCode BCFirstName BCLastName

W JD Jane Doe
E JJ Jo Jones


I have another control on my main form named [strRegion]. When you select a
BCCode I would like the region to populate to either W or E based on the
BCCode that you select. Is this possible?
 
Take a look in Access HELP (or on-line, in search) for "cascading combo
boxes". This is the term that is used to describe having a second combo box
limited based on choice in a first.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top