Sub Combo Box

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

Guest

I want to create a combo box that has different options depending on the
information contained within another field.

The field I am concerned with is CrimeType. There are three options; theft,
robbery and burglary. I then have another field named SubCrimeType. I want to
be able to look the content of this field up through a lookup table but when
the original crime type is theft, I only want the sub crime types associated
with theft to be shown. Clear?

I realise I will have to do this through lookup tables or combo boxes but I
am unsure how. Please can you help?

Thanks
 
This is called synchronising combo boxes. You would have a combo for your
Crime Type with a fixed Row Source. In the After Update event of this combo
you would set the Row Source of the SubCrimeType combo depending on the
value of CrimeType. Searching this forum for synchronised combo boxes
should give you plenty of links to examples.

HTH
 
Back
Top