Form to use 3 cascading comboboxes that also saves variable cost

[drewship]

Hello.

Hopefully my situation is not too difficult for someone to assist me with,
but I need a form that has 3 cascading combo boxes. The first selects the
Product, second=BeginDate, and third=[Service Type]. I believe I can save the
results of these combo boxes to my table, but the issue for me is that there
is a variable Cost associated with the [Service Type] that needs to be saved
as well.

The Cost is based both on the BeginDate and the [Service Type]. If the
BeginDate =1/1/2009 then the [Service Type] items after 1/1/2009 would be
displayed in the third combo box to be selection. If the BeginDate =1/1/2010
then the [Service Type] items after 1/1/2010 would be displayed in the third
combo box to be selection. The Cost for the various [Service Types] is
different for 2009 and 2010.

I have a ProductOptionPeriodRepair table that currently contains all
information for the combobox selections as well as the Cost. Everything will
be saved to another table for reporting.

Thanks in advance for your help!!