I have a continous form that has a Query as its source. The form uses
5 fields, two of which are Combo Boxes. When I place the cursor in
one of the fields and hit the A>Z sorting button, everything sorts
fine and I can continue editting the data in the Query, except for one
particular Combo box -- when I sort based on its contents, the form
locks and every time I try to edit any of the fields, I get an audible
'bonk' telling me I can't edit it (no error message is given). Even
if I close the database and open it again, I still can't edit the
fields. I have to go into the Design View any edit the "Order By"
property, which was populated by the value
Lookup_cbxProdu ct.Product
from the sort. If I clear this value, then everything works fine
again. This doesn't happen with the other Combo Box.
Thanks,
Rich
5 fields, two of which are Combo Boxes. When I place the cursor in
one of the fields and hit the A>Z sorting button, everything sorts
fine and I can continue editting the data in the Query, except for one
particular Combo box -- when I sort based on its contents, the form
locks and every time I try to edit any of the fields, I get an audible
'bonk' telling me I can't edit it (no error message is given). Even
if I close the database and open it again, I still can't edit the
fields. I have to go into the Design View any edit the "Order By"
property, which was populated by the value
Lookup_cbxProdu ct.Product
from the sort. If I clear this value, then everything works fine
again. This doesn't happen with the other Combo Box.
Thanks,
Rich