Hi,
I have a form (Datasheet View) with two fields on it, one is a combo-box which is set as control source of the PK of the table and the other is a description.
I use a combo-box with a query so the ID is used as the key but the company name is shown for selection in the combo.
This works fine until the form is sorted or filtered, then none of the recrods can be changed with a message stating... "This record is not editable"
Why? and how do I make it editable?
Thanks,
1DMF.
"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."
"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Dance Music Downloads
I have a form (Datasheet View) with two fields on it, one is a combo-box which is set as control source of the PK of the table and the other is a description.
I use a combo-box with a query so the ID is used as the key but the company name is shown for selection in the combo.
This works fine until the form is sorted or filtered, then none of the recrods can be changed with a message stating... "This record is not editable"
Why? and how do I make it editable?
Thanks,
1DMF.
"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."
"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Dance Music Downloads
