sorting a screen and combo locks

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I have a form that is a continuous form. It displays open records. On the
form is a combobox that allows the user to change the status of the record.
This cbo works like it should when the form is opened and nothing else is
done. The continuous form can be sorted. But when the sort occurs, the cbo
for the status does not allow the user to change the status. My first
thought has to do with the qry behind the sort is not allowing the user to
change the status. Or would there be another reason? Is there a way to work
around this?
Thanks... John
 
JohnE said:
I have a form that is a continuous form. It displays open records. On the
form is a combobox that allows the user to change the status of the
record.
This cbo works like it should when the form is opened and nothing else is
done. The continuous form can be sorted. But when the sort occurs, the
cbo
for the status does not allow the user to change the status. My first
thought has to do with the qry behind the sort is not allowing the user to
change the status. Or would there be another reason? Is there a way to
work
around this?
Click to expand...

What do you do to sort the form? Are you using the built-in sort button on
the toolbar, or are you running some code or a macro? If the latter, please
give the details.

Is the whole form non-updatable after sorting, or just the field that is
bound to the combo box?
 
Sorting is done thru a combobox and button at the top of the form. So the
click event of the button has a qry behind it for the different sorts. That
is what made me at first think it was the qry as there are JOINS in the qry.
The whole form is non-updatable when it sorts. I might have found a way to
overcome the issue and would like to give it a try. I will reply back as to
whether I am successful or not.
Thanks...John
 
I got it. I modified the qry behind the click event of the sort button. All
fields are now able to be updated.
Thanks for taking the time to review the post.
.... John
 
Back
Top