combo box control source

[Selene]

Hello All,
I have a subform within a form. In the subform (Entitlements) I have two
combo boxes. I would like the second combo box's (entitlement id) selections
to be based on what was selected in the first combo box (entitlement). ---
The subform is based on one table with multiple(but limited) "entitlements".
Each entitlement has it's own unique set of id#s. (i.e. new entitlement PDP
has id#1718, but new entitlement CUP has id#838). If one selects "PDP" as the
entitlement in the first combo box, then I would like the second combo box to
only show the id#s for "PDP" not "CUP" or any other. I am hoping to do this
w/out multiple tables (for each entitlement)....Also IF POSSIBLE, I would
like to be able to have it enter the next corresponding Id# (based on the
selected entitlement) in the entitlement id# field (without autonumber). I
had limited succes with the first part, but only on the individual
entitlement form, not as a subform. I am new at access. Please help.

 

[Allen Browne]

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm