Limiting Combobox Values based on Selection in previous subform record???

[Kroghr]

I have a subform called FrmPassengerManifest, in the subform there is a combobox called SeatID. SeatID contains values; 2A 2C 3A 3C etc.. I'm trying to figure out a way to limit the SeatID combobox values bases on the prevoius records in the parameter query based subform. Any help would be greatly appreciated.

 

[John Big Booty]

What you are trying to do sounds like a variation on the Cascading Combo Box theme.

However if your subform is a continuous form you are not going to get this method to work for you. So you will have to consider an alternate method of achieving your desired goal.

 

[highandwild]

Do you know the ID of the previous record in the subform.

What order are the subform records in?