Auto update fields - HELP

  • Thread starter Thread starter John Cook
  • Start date Start date
J

John Cook

Have cretaed a database to register telephone enquiries
but have run into a dealend trying to enhance it. I NEED
HELP!
To try and put it simply.
I have 4 sectors each with numerous depts. The depts are
selected on a form from a dropdown combo box, and I want
the Sector box to be completed automatically.
If "Microsoft" is the selected Dept, the Sector box on the
form would be automatically completed with "Computers"
from the Sectors table. Dept and sectors are in separate
tables on which I have created a relationship.
All help gratefully received - whilst I still have hair.
 
John,
Add a second column (Sector) to your Dept combo. Ex...
Dept Sector
Microsoft | Computers
Symantec | Computers
Bose | Electronics etc...

On the AfterUpdate event of Dept set the value of Sector on the form...
Sector = Dept.Column(1) (or whatever column it's in)
hth
Al Camp
 
Back
Top