Offer combo box choices based on current value of combo box in MS Access

[skwilliams]

I have a form with a combo box [cboStatus]. The combo box has the following values.
Need, Active, Complete, Out, Ordered, Received, Transfer and Void.

I would like to display specific values in the combo box based on the current value.

For example, if I go to a specific record and the status is currently "Need", then my only choice in the combo box should be "Active". If the current status is "Active", then my only choices should be "Out" or "Complete". Etc.

Any ideas???

 

[pbaldy]

I have what sounds like a similar situation; a single status field, but only certain statuses can be chosen from certain others. In my case, I left all the statuses listed and I use the before update event of the combo to evaluate the previous and new selections to determine whether that change can be made.