Hi,



I have a quick question regarding building dynamic combo boxes.  Basically I

have two combo boxes and the second box has to be built based on the choice

made in the first.  Obviously this will require a series of If or Switch

statements, however what is the best method of adding new options to the

second combo box?



Mark

Have a look at



http://www.mvps.org/access/forms/frm0028.htm



That's actually a great site for all sorts of FAQs...



Cheers,



-Roy



-----Original Message-----

From: Mark Irvine [mailto:markpirvine@b...]

Sent: Monday, August 20, 2001 7:49 AM

To: Access

Subject: [access] Dynamic Combo Boxes





Hi,



I have a quick question regarding building dynamic combo boxes.  Basically I

have two combo boxes and the second box has to be built based on the choice

made in the first.  Obviously this will require a series of If or Switch

statements, however what is the best method of adding new options to the

second combo box?



Mark