Hi everybody,
I did a search on the error but non of the answers are solving it. Anyway, I've got a form and subform. A combo box cmbFrm on the form filters subform to a value it displays. A combo box cmbSub on the subform has onLostFocus event. Now if I do following:
cmbSub looses focus
cmbFrm gets focus and filters subfrm accoring to its value
cmbSub gets focus
cmbFrm gets focus and filters subfrm accoring to its value
My actions sounds odd but if I repeat the above 3-4 times then straight after action "cmbFrm filters subfrm" I get the following error:
Run-time error '2424': The expression you entered has a field, control, or property name that Microsoft Access can't find.
...and it points on onLostFocus event that belongs to smbSub combo box.
The question is why cmbFrm, fires onLostFocus event that belongs to cmbSub???
any ideas are welcome
Thank you
I did a search on the error but non of the answers are solving it. Anyway, I've got a form and subform. A combo box cmbFrm on the form filters subform to a value it displays. A combo box cmbSub on the subform has onLostFocus event. Now if I do following:
cmbSub looses focus
cmbFrm gets focus and filters subfrm accoring to its value
cmbSub gets focus
cmbFrm gets focus and filters subfrm accoring to its value
My actions sounds odd but if I repeat the above 3-4 times then straight after action "cmbFrm filters subfrm" I get the following error:
Run-time error '2424': The expression you entered has a field, control, or property name that Microsoft Access can't find.
...and it points on onLostFocus event that belongs to smbSub combo box.
The question is why cmbFrm, fires onLostFocus event that belongs to cmbSub???
any ideas are welcome
Thank you