Limited cboBox in Datasheet View

[FrymanSMU]

I have a combo dropdown that is limited by another field on the subform. It works great for the first record but when you enter the data in the combo limit for the second record the data in the prior record disapear when it is not within the limited dataset. The form is bound to the table.

Is there any way to fix this? Or do I need to create an unbound form?

[CreganTur]

It sounds like your Form is technically working correctly- if a record doesn't match what the combobox states as criteria, it isn;t included.

What are you trying to accomplish- what do you want it to do?

[FrymanSMU]

Well this is a input datasheet form, actually a subform, for a group of users to input information. I have two combo box/dropdowns, the first selects a group that limits the second drop down. That part is working correctly. The problem is when the user moves to the next record, the data in the previous record disapears.

[CreganTur]

By "disappears" do you mean the changes were not written to the underlying table?

[FrymanSMU]

No the data is still stored in the table but the user cannot see what was selected in the prior record, if the limit changes.