How to undo efects of the A|Z sort- URGENT

  • Thread starter Thread starter ljubo lecic via AccessMonster.com
  • Start date Start date
L

ljubo lecic via AccessMonster.com

I have simple continuous form.I was entering data and everything was OK
until I did the sort once by the
A|Z sort in the tool bar. Afterwards I can't make the form to behave in the
earlier manner.After each insert
focus goes to the first record.All I tried to undo the
efects of the sort was in vain.HELP please!
 
ljubo lecic via AccessMonster.com said:
I have simple continuous form.I was entering data and everything was
OK until I did the sort once by the
A|Z sort in the tool bar. Afterwards I can't make the form to behave
in the earlier manner.After each insert
focus goes to the first record.All I tried to undo the
efects of the sort was in vain.HELP please!
Click to expand...

I'm not sure what's going on with your form, as it oughtn't to be
requerying or shifting the focus to the first record in the absence of
code to make it do so. However, you can remove the effects of your sort
this way:

1. Open the form in Design View

2. Open the property sheet for the form.

3. Go to the Data tab of the property sheet.

4.Delete whatever is present on the Order By line of the property sheet.

5. Close the property sheet.

6. Save the form.

When you open the form again, the sort you previously imposed should be
gone.
 
Back
Top