I have several fields in a form.  The recommended option field is a
calcuation that gives me a result of #1-#4.  My end-user is to select the
type of reports available to them depending upon the recommended option so I
need that combo box to only show the option availalbe to them.  The form is
continuous so I need it to change the options available each time the
end-user gets to a new record.  Using an If statement becomes to lengthy and
gets truncated.  Any suggestions please?

Recommended Option         Report Type
1                                           A
1                                           B
2                                           A
2                                            B
2                                            C
3                                             A
3                                            C